Formulas
Discussion List
- I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not …
- I want to have a condition where IF Delivered column checkbox is checked, then that whole row will be deleted. Is that feasible? Can you please guide me how to start with it?
- I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth …
- Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
- Hello, I'm trying to create a Nested IF formula utilizing the status bars and due dates. What we're trying to say in English is: If more than 5 days til due date = Green If within 5 days of due date o…
- Hello I have read a few posts about calculating values between dates but I'm still having an issue. I am trying to calculate a numeric value (basically a go-live date for 3 different project types) wi…
- How do I create a formula to subtract 30 business days from a certain start date? I was trying to use =WORKDAY ([start date]13, -30) and it's not working. Note: the 13 is the row with the date I'm cou…
- I'm trying to set up notifications for milestones that my team hits, looking for a specific ticket # in a column to send a notification when this ticket # is hit (for example, "Hey team, we just close…
- Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 10…
- Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children t…
