Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

THANKS to all the Formula Gurus!!!

Tim Meeks
Tim Meeks ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

Dear Fellow community, 

 

While I know Excel rather well..VLOOKUP, PIVOT TABLES, etc, the LOGIC and IF formulas sometimes cause me trouble. Anybody with me.?? Frown

 

OK.. so I'm doing what my daugther calls a "humble brag"  cause I'm tooting my horn, but giving credit to others.....Wink

 

Today (with lots of help and patience), I was able to create a (working) formula that contains the IF, AND and ISDATE commands.

 

=IF(AND([DOCUMENT TYPE]1 = "Termination Request Form", ISDATE([COPY TO OSP]1)), TODAY(), "")

 

And if that wasn't enough, I was able to create a formula with SIX (6) NESTED IFS!!!!

It only took me 2 hours... and 30 minutes of that was finding where I was missing a darn comma!!

 

=IF([DOCUMENT TYPE]11 = "Modification Request Form", [COPY TO OSP]11 + 49, IF([DOCUMENT TYPE]11 = "Renewal Request Form", [COPY TO OSP]11 + 49, IF([DOCUMENT TYPE]11 = "Pre Approved Vendor Request Form", [COPY TO OSP]11 + 49, IF([DOCUMENT TYPE]11 = "Sole Source Procurement Request Form", [COPY TO OSP]11 + 49, IF([DOCUMENT TYPE]11 = "Non Solicitation Request Form", [COPY TO OSP]11 + 49, IF([DOCUMENT TYPE]11 = "Interagency Agreement Request Form", [COPY TO OSP]11 + 49, ""))))))

 

So I want to thank several of you who gave me inspiriation:  such as Travis, John Sauber, John Hinkle, Brett Evans, J. Craig Williams and Atus Bartal!!   And the Formula Example Sheet and FAQ!!  There are others, but when I grow up, I want to be like these guys!

 

So for those like me who need some encouragement with formulas....keep working at it!!

 

Tim

 

Tags:

Comments

This discussion has been closed.