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

Help to identify all x.x.1 cells
I have a WBS column that I'm joining with a resource row count to provide a distinction for tasks not just by hierarchy but by resource. I need to be able to exclude the very first task per assignee in the first hierarchy only. How do I identify only the x.x.1 tasks in a column? I need to create a formula for all RBS =…
Flagging dates overlap
Hi Smartsheet stars, I try to flag jobs overlaps using COUNTIFS function as per screenshots below (tried two different options), however, it doesn't show me 3 overlaps I currently have in my Smart sheet (I created a new A and AAA projects with conflicting dates but it has not been flagged for some reason). Could you please…
Trying to get an accurate count of checked boxes in a report
hi there, I am trying to get my report to only count boxes checked in each row. instead, it is counting the checked and unchecked boxes, which doesn't translate into my dashboard report. Is there a way to make sure it only counts check boxes for each summary?