Formulas

Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing…

Hi all I am trying to figure out why my formula isn't running correctly. I want to count how many times a specific segment put in a request per month. For Example if the nurse team made 10 request in January and 12 in February. I have about 10 other segments to fit in. I also only need to count Parent rows which are…

Hello! I'm running into a strange issue with my networkday formula. I'm trying to keep track of time off requests as they are submitted. The following formula was working for me as of now. =NETWORKDAY([Start Date]@row, [End Date]@row) However, I noticed that the count wasn't correct as some people were including company…

I'm looking for a way to calculate the Monday after an event date, to trigger the next step in my project plan. Any ideas? Thanks in advance!

Hello all, I need help writing a formula that looks at a date field (which may have multiple entries) to see if it contains any dates within a set range. For example: if the "Date" field contains any dates earlier than May 5, 2022, return "1", otherwise, return "0". Here's where I'm at... =IF(CONTAINS(Date@row < DATE(2022,…

I need some help with a formula that is partially working. I've tried a few ways to code this, but gets an error so I'm probably missing something... During our intake process using Smartsheet a form can be filled out by multiple people. To my knowledge, there isn't an easy way to prevent multiple submissions for the same…

Hello Smartsheets Friends, Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve. 1-7 Days from Handover Date = Activation Call Status - Green 8-14 Days from Handover Date = Activation Call Status - Yellow 15+ Days from Handover Date = Activation Call Status - Red When customer…

Hello, How do I prevent LEN from counting spaces between words as characters? Thank you. =LEN([Letters]@row) * 10.75 * Height@row

Hi Community, We are happy to announce the addition of the TotalFloat function to Smartsheet’s powerful set of Project and Portfolio Management capabilities. The TotalFloat() function calculates the number of working days that a task can be delayed without impacting the Project Finish Date. This new formula function will…