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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!