Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2016, 02:36 PM
Planner18 Planner18 is offline Formula help Windows 8 Formula help Office 2010 32bit
Novice
Formula help
 
Join Date: Oct 2014
Posts: 14
Planner18 will become famous soon enough
Default Formula help

Hi All,



Does anyone know the formula that will copy the start date into the text 1 column if any rows in the flag 1 column are set to yes?

Any help would be appreciated

Thanks

Planner18
Reply With Quote
  #2  
Old 12-29-2016, 07:56 AM
Guloluseus Guloluseus is offline Formula help Windows 7 64bit Formula help Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

try

IIf([Flag1]=True,[Project Start],"")

this assumes that by start date, you mean the project start date. If flag 1 is set to no, (false) I have set the formula to insert a blank, this avoids showing an error message. If you want something different, it can go between the 2 quotes ("").

If you want to show the start date of the task, it would be

IIf([Flag1]=True,[Start]," ")

hope that helps.
Reply With Quote
  #3  
Old 12-30-2016, 03:18 PM
Planner18 Planner18 is offline Formula help Windows 8 Formula help Office 2010 32bit
Novice
Formula help
 
Join Date: Oct 2014
Posts: 14
Planner18 will become famous soon enough
Default

Perfect! Many thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula help Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Formula help IF + AND formula help david_89_ Excel 4 06-11-2014 11:07 AM
Formula help WHEN formula agent007 Excel 5 02-06-2014 09:20 PM
Formula help Need Help w/Formula OSCAR MARTINEZ Excel 1 09-28-2013 05:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft