-
Formula to assign colored dot symbol based on field?
Hello all. I am trying to utilize the colored symbol dots (green, red, blue, etc) while also having a text field specifying what the status of an item is. In my case, I am looking to have the following: Column A (Status) ------ Column B (Status Dot) Available ------ Green Pending ------ Yellow Unavailable ------ Red I wantβ¦
-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if aβ¦
-
How do I set dates depending on another task being completed?
If we speak with someone that completed a questionnaire we will follow up with them in 28,35,42 days. I am able to set the dates to be prefilled but how do I set the condition that if only the questionnaire was completed or is "green" we should enter the follow up dates? We have a column to show green or red forβ¦
-
Counting Multiple Values in One Cell
Hello, We have a form with a multi-select option for "Event Type". I am trying to create a new sheet that can be used within a dashboard with a chart that shows how many "Event Types" there are within a given "Delivery Format". Snippet of sheet collecting form submissions below. The formula I was using to try and find theβ¦
-
How to Record Data Weekly
Hi, I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed. Isβ¦
-
How to combine multiple IF statements into one?
Hello! I have 3 different IF statements in 3 separate columns that I would like combined into 1 if possible. The three IF statements/columns are the following: Red Status - if task is in the past and not checked complete: =IF(AND([End Date]@row < [Today Helper]@row, [Task Complete?]@row = 0), "Red", "Green")=IF(AND([Endβ¦
-
Date column triggering urgency status column
Hello! I have three columns: 1. Date 2. Checkbox 3. Urgency status If the date populated in the Date column is one week or sooner from today's date, and the checkbox is unchecked, I would like the urgency status to be yellow. If the date populated in the Date column is past today's date and the checkbox is unchecked, Iβ¦
-
Counting # of tasks from a specific parent
Hi all, I am trying to count the number of tasks in my plan underneath a specific heading. However, I am unsure how to do this for 1 parent heading and not all of them. For example, I am looking to find the number of tasks under plan stage 2. Plan stage 1 Plan stage 2 Plan stage 3 I would use "=COUNT(CHILDREN([Taskβ¦
-
Workflow - recognising email domain as part of "assigned to" column
Hi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "firtstname.lastname@smartsheets.com". However in the field it would show up as "firstname lastname" without the domain at the end Company - dropdown box with 2 companyβ¦
-
Adding hours to a date
Hello, I have the following columns in a sheet: "Created (Date)" records the date/time a form was submitted. "Modified (Date)" records the date/time a row is copied to the final sheet in my workflow. I want to compare the modified date to another date that is manually entered in the row to determine when to send aβ¦