Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Automated Updates

When I send and update request to more than 1 person - I understand I can add an Action to lock the row such that subsequent updates fails.

1) Is it possible to capture who updated - into a cell ? Writing a comment shows who updated - so I assume somewhere this information is collected.

2) Would subsequent updates be possible on the UI or would it fail when the form is loaded? Would the user be informed of update failure ?

ps: newbie reviewing smartsheet.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • Trying to count if a cell by criteria if another cell contains "device": =COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]…
    User: "dharberts"
    Answered ✓
    10
    3
  • I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get …
  • I am trying to make a cell read "Yes' or "No" based on criterion from another sheet. Basically, if all projects under a certain package have set schedules then the cell should read "Yes" and vice vers…
    User: "Daniel Barber"
    Answered ✓
    23
    2