How do I bring over select fields from Sheet A to Sheet B if Sheet A's submitted date is today.

Hey Smartsheet,

I have two Sheets and am trying to bring over Staffing Level, Collections Scheduled and Collections Absent from Sheet A to Sheet B if the submission was today for matching Departments. (Incases of multiple entries I want to bring over only the latest submission)

I've tried Max/Collect with Today formulas but cannot get the syntax right.






Thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!