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…
Hello Smartsheet friends, I've found several past due or days before past due formulas but have not been able to find one specific to this case. We use a smartsheet for account management. I would like to have a cell turn a color based on the variables below, based on how many days have elapsed past the date in another…