I am wanting that after someone has entered information on someone 3 times it triggers an email to be sent or action to be taken. Is SmartSheet able to do this?
I think we may need more information. Will this be entered on 3 different rows for the same person, in 3 different cells on the same row, in the same cell 3 different times?
Depending on how you are getting the updates, you could potentially use helper column(s) and automation to update the value of cell(s) with 1,2,3 and then trigger additional automation.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
©2024. All Rights Reserved Smartsheet Inc.