I want to have the system count the number of days from when an item has been approved, and if it has been longer than 7 days without a PO being sent to the customer I want it to send an alert to a person
You can set up a flag type column. The formula to flag rows where there is no sent date but the approval date is more than 7 days in the past would be:
=IF(AND([PO Sent Date]@row = "", [LN Approval Date]@row< TODAY(-7)), 1)
Then you would set up your automation to rn based on when this column gets flagged.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Thank you so much
Happy to help. 👍️
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
©2024. All Rights Reserved Smartsheet Inc.