-
IF and ISDATE Formula
I want to calculate NETDAYS from Submission Date to Todays Date, or to Comments Log Received Date I have this formula that works. =IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row)), "") However, I need to expand…
-
Formula - Helper Column Flag if Duplicate
Is there a formula I can use in a helper column to flag an entry if a duplicate already exist? We are going to share add forms with 100+ people to enter information about their employees. The last time we did this many of them entered duplicate employees causing a lot of chaos. The goal is to send out alerts/notifications…
-
Formula Needed to Check Time From Created Date and Put Into 2 Statuses
Hi All, Trying to work with Created Date column to extract the time from Time Stamp, then look at the time to determine if it falls within two statuses. This is for a Rush Payment Cutoff Time. If an entry is submitted in our sheet before 1pm that day, I want the column to say "Same Day" and if after 1pm, have it say "Next…
-
Why is this #incorrect argument set
=SUMIF([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ") I'm trying to show the completed tasks in the contacts column, and specifically for the contacts individually.
-
Date Formulas
Hello Everyone, I'm new to the smartsheet community, but have been using smartsheet at a basic level for a few years now, and I am looking for some help. I have a form that collects information for me. Each time the form is completed and submitted it creates a new row in my sheet. In my sheet, I have a column called an…
-
Trying to return the date if a certain row task is marked Complete
After spending some time learning about a bunch of different things in Smartsheet that aren't helping with my problem, I thought I should just ask my question. I am missing something small I think. I have tasks in my projects that need to be completed after it is implemented. I want to capture the "Execution Complete" task…
-
Column has a formula, need answer as a multiplier
C Value column is a formula =IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31…
-
Parent Flagged if Children Flagged
Hi all. I have a task list that consist of multiple parent rows with Children I have modifided so that if a task is delayed or dates are not added in the task will get a flag. What i would like is to have if one or more of the Cildren Rows are Flagged the parent row will be flagged. but cant figure it out. Ivé tried with…
-
Could someone help me with this formula?
We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9 digits, but many times they don't enter all the numbers. I read about helper columns to check whether or not the format is accurate and then send an…
-
Formula not working
Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated! Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red =IF(ISBLANK([RegSci Review…
