-
Invalid Operation when using Today() in nested IF STATEMENT
Here is the formula I am working with: =IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@row > TODAY(), "In Progress", "Complete")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…
-
Trouble with duplicate entries with FORMS
Hello, I created a form for requests but I am seeing a lot of duplicate entries. I am trying the following formula with no success. Does anyone have any other ideas?
-
Return the last text value from a multi-column search
I have 5 columns from left to right: 'Site 1', 'Site 2', 'Site 3', 'Site 4', 'Site 5'. I am looking to search each column by row to see if there is a value entered into each site column. If a value is entered, I'd like to return the last site that has a value into a new column labeled 'Latest Site' (e.g. Site 1 and 2 have…
-
Why my workflow won't send to two contacts
Hi there, I have set up an automation for alerting a manager when a task date is moved out or a task is completed. At times I need to add more than one contact. When I test with two contacts, only one of them receives the alert. Both contacts are in the "Mentor" field What am I doing wrong?
-
Why has my metric sheet stopped working?
The following table counts data from a sheet using COUNTIFS functions. EG countif it a question and = the row or countif its an alternative proposal and the row. However the its stooped counting. For example there are 5 'Role specific' questions in the sheet but the table below shows 3? And there is one Alt. prp but none…
-
Help with Multi IF Formula
Hello, Relatively new to SmartSheet and formulas and have come across a block.. needing some help from you wonderful people :) I have a "Site" dropdown column with "SiteA" "SiteB" and "SiteC" as options. then a status column for each of the 3 sites (as below) What I need is a formula that looks at what sites are in the…
-
How to calculate the number of teammates who will have a birthday in the last 7 days?
We are using TODAY() formula to define our teammates' birthday as below snapshot, but how can we use the formula to calculate the count of who will have birthday in the coming 7 days in summary? Thank you!
-
Formula issus while automation
Hi All, I am currently having an issue for one o my workflow, I will try to describe briefly: I have a ticket system that we use for one customer. Whenever a ticket is completed in the "Open ticket sheet" by our Team, the line is moved to an "archive sheet" thanks to an automation. In the open ticket sheet, I have this…
-
Categories item number given
Hello Dears, I hope my email finds you well, I have seen your videos about Smartsheet and they are accommodating, I am stuck in a function I need for my Smartsheet if you can support me. The idea is, I have a category and in this category, I have 5-6 items and need a function that shows me in each column next to the…
-
Help with multiple criteria formula!
Hi Guys, I'm trying to do a difficult job here but the best way to explain it is as the end goal we want a display dashboard that shows a % of where our current sales and invoice are for the month live so it doesn't need to be manually updated so when we add rows it doesn't need maintenance and converted to percentage to…
