Formula help

		Microsoft Office Forums > Microsoft Office > Project
Formula help

FAQ

Thread Tools

Display Modes

12-29-2016, 07:56 AM

Guloluseus Guloluseus is offline

Windows 7 64bit Formula help

Office 2010 32bit

Competent Performer

Join Date: Mar 2013

Posts: 168

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
IF + AND formula help	david_89_	Excel	4	06-11-2014 11:07 AM
WHEN formula	agent007	Excel	5	02-06-2014 09:20 PM
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 04:27 AM.