How do I place a date in a column when approved is marked in another column

Rocky

Rocky ✭✭✭✭

01/09/23 in Formulas and Functions

I would like to use the IF function

IF(RMReview@row=Approved or Rejected,)

The formula is unparseable and I agree. I just don't know what to place in the formula to get a date.

Appreciate the help!

Thank you very much,

YCRock

0 ·

Answers

Samuel Mueller Overachievers

01/09/23

@Rocky I would use an automation "Record a Date"

0 · Share on Facebook Share on Twitter
Rocky ✭✭✭✭

01/09/23

ok.. that sounds good! I'll give it a shot. Thanks!!

Thank you very much,
YCRock
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
Logic formula to return a value on another sheet based on two search criteria
I am trying to develop a formula that will return a request ID # to an invoicing sheet. The source sheet includes the request ID # and two columns with the criteria I want to be met (Lot Charge Fee, Ready to Invoice). I want the request ID # to only show up on the invoicing sheet if the following criteria is met: Lot…
Extracting all text from a cell to the right of a symbol
Hi, I'm trying to extract all text from a cell after the hyphen "-" symbol. There may be a long text string after the hyphen, not a set number of characters. I can get it to extract words to the left of the hyphen using the LEFT function but when I try to use RIGHT it cuts off part of the text? Top row formula in Short…