-
Overall response status is getting removed...
I am trying to provide a status on our department response time. We have 30 days to respond to another department for requests, once they are received. 1) I wanted to put a Green, Yellow, and Red status on the request, based on if the open request is: a. greater than 14 days until the due date, (Green) b. greater than 7…
-
Automatically have End Date initially match Start Date
Is there a way for an End Date to always automatically match to the Start Date, but for me to have the flexibility to then select a different date if needed?
-
Count if older than
Trying to count the number of dates that are older than "Todays" date by 14 days. So if today is 4.16.21, anything that was listed in my date column that is 14 days older than 4.16.21 would be counted. Example: Date Colum has 2 rows filled out. Row1 - has a date of 4.16.21 Row2 - has a date of 4.1.21 The formula cell would…
-
Count Function
My excel spreadsheet that I'm attempting to replicate uses the following formula to count if any value is listed in column M. =COUNT(All!M:M). So if I have 3 items/rows listed in Column M it would return a 3, regardless of the value of the individual cells. Example: Column M (Row1)5 (Row2)6 (Row3)7 Formula cell with,…
-
Current Week and Next Week Formula
Hi, I need help with a formula that will help me determine if a date is the current week or the next week in the calendar. Need the weeks to star on Sundays. I'm using the following two formulas: For Current Week I'm using the following formula, which is working fine: =IF(AND(YEAR(TODAY()) = YEAR(ChangeDate@row),…
-
IF #INVALID OPERATION
Hi I am using this formula to define Health of the project with symbols in the summary sheet =IF([Gap vs SMS]15 >= 14, "Yes", IF(14 > [Gap vs SMS]15 >= 0, "Hold", IF([Gap vs SMS]15 < 0, "No"))) Formula works ok, but when I copy to other sheets, a few of them appear with invalid operation and I can´t find what could be…
-
URL Query String to Populate a Form - Issues with " \ % characters
I'm playing around with the URL Query String to populate a form with data from one sheet to add it to another sheet (essentially, to copy rows, but only the columns I want). The problem I'm having is that at least 1 of the fields is a description field and can be quite long and have a gazillion special characters in it.…
-
Question on IF / AND OR Formula
Hello, I have this formula that works great. I would like to add one criteria to it, however. If a new column (not currently referenced here, which contains a "priority status" (different than "status") that is "high", the dot should be red, regardless of any other critera. =IF(OR(Status@row = "Dead", Status@row =…
-
Formulas to identify duplicates
My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.
-
Why is an automated alert no longer working?
Our company has been using Smartsheet for over a year to organize the production process in our shop. Clients submit orders through a form, and when the order is added to the Sheet, we have an automated alert that is triggered to send a copy of the approval to 2 different email addresses. Suddenly one week ago, the…