-
Long IF Statement Help
Hello, I am attempting to create an IF statement on a Red, Yellow, Green, Grey icon text type with multiple factors. Below please find the inputs listed. If new entry then Gray (COMPLETED) =IF([Form Submission Date]@row = TODAY(), "Gray") If hard deadline has passed and nurse intake has passed then Red (COMPLETED, but…
-
Multiple IF statements
I am trying to use multiple IF statements and it is not working. For example, I have a column called "HCSA Goal Alignment" which has three conditions that a user can choose. The three conditions are: · Does not meet (Low priority = 5 points) · Partially meets (Medium priority = 10 points) · Completely meets (High priority…
-
Increasing date
Hello, I am trying to make columns that show each Monday based off of a Start Date. If the start date is 9/13/2021, the next one should be 9/20/2021, and the next column 9/27/2021. I had a formula that was working just fine until it stopped for some reason: =Start Date + 7*(week #) I'm not sure why that formula stopped…
-
Creating an email out of a full name
Hi, I am trying to make an email out of a full name cell and am running into issues when trying the Right/Left method (ex: =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)) and =LEFT(A2,SEARCH(" ",A2)). When trying the above method, the Left would not work (was going to split them up and bring back together with CONCATENATE). All emails…
-
Sheet Formula_ Heath symbol
Hello everyone, I know I am close, but looking for some help. I am trying to create a formula to calculate If start date is less than today, health symbol is Green If start (maybe should be end date) is within (xx) days, health symbol turns yellow If start date (maybe should be end date) is greater than today, turns Red If…
-
How to do a Pivot Table without the Pivot App
I'm currently importing an excel file via Datashuttle on to a sheet for the sales team to confirm reward payments to partners with fortnightly updates. I do though need to identify the partners that are close to their yearly "reward Cap" and was planning on sending this via a Metric Sheet to a Dashboard. Any thoughts on…
-
COUNTIFS Using Multiple Criteria
Hi, Is it possible to use COUNTIFS with multiple criteria. I would like to count the number of dates in one column that are past the dates in another column, however if a date cell in either column is blank I don't want it to be included in the count. Thanks Richard
-
Auto trigger workflow (after file upload to Smartsheet)
Hi Smartsheet community Process: 1) Excel file uploaded to Smartsheet 2) auto trigger workflow to check if "column_name" contains "Expired" 3) if "column_name" contains "Expired" then send email to "Employee_Email" Appreciate guidance and help. Thank you
-
How can I copy data from just a few columns to another sheet?
I have a large sheet where I would like to copy the data from just 7 columns to another sheet once the data in one of the columns matches the criteria needed. For example: Copy the data from the following columns to NewSheet once the Group column says October 2021. Position Accepted, ID, FName, LName, Instructor, Email,…
-
How to specify format for date formulas?
Hi all, If I'm using a formula such as '=MONTH(TODAY()) , how do I tell smartsheet to return the name of the month instead of the number? eg: "September" instead of "9" In excel it would be '=TEXT(TODAY(), "mmmm") but this smartsheet doesn't seem to like this. What is the smartsheet equivalent? I am not prepared to prick…