-
Column Formula Changes - Change Cell Value
Hi Community, I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad", I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working. I have another Automation that if it changes to a 2 or 3 it alerts soneone,…
-
Conditionally changing cells
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…
-
Counting Monthly Intakes per Segment
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…
-
Networkday formula with Cross Sheet Reference to Holidays Sheet
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…
-
Formula to calculate the Monday after a date
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!
-
Need formula to evaluate a date field with multiple entries
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,…
-
Need help vlookup and a migraine. Help with vlookup may help with migraine.
-
IF Multiple Codes have open Status then Duplicate is True
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…
-
Help with RYGB Formula for Days past Start Date, Blue = Complete Status from Multi Select
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…
-
LEN counts "Space" as a character
Hello, How do I prevent LEN from counting spaces between words as characters? Thank you. =LEN([Letters]@row) * 10.75 * Height@row