-
How to use MATCH function on multiple columns at the same time?
I've used the MATCH function before on the "City" and "CityMATCH" column. It worked out well. This is the formula that I used: =MATCH(City1, CityMATCH:CityMATCH, 0). I've now added another column called "Number" and "NumberMATCH." What I want to know is whether "3" in the "Number" column and "Chicago" in the "City" column…
-
Traffic Light Conditional
Hi, I'd like to know if possible to do the following in Smartsheet. I want to have a traffic light cell (green, red and yellow) that every time I open the sheet it would change base on: Green - if the contract end date is 15 days from today Yellow - if the contract end date less than 15 days from today, and Red if the…
-
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…
-
COUNTIFS ?
Hello - I have 4 symbol (Red, Green) columns (Named: Step 1, Step 2, Step 3, Step 4). I am wanting to count the rows where Step 1 is Green and Step 2 is Red. I came up with this formula, but for some reason it is not working. Any ideas why? Thanks!!! =COUNTIFS([Step 1]:[Step 1], "Green"), [Step 2]:[Step 2], "Red")
-
Inventory Sheet Evaluating - Locations in Multi Select Column
On my inventory sheet I have a list of items in rows. For each row-item I have a column with a multiple-select to identify how many locations have that item. On a separate sheet, I'd like to be able to type a location and populate all the rows of inventory items that live at that location. Any advice on which formula to…
-
history of automation to 'alert someone'
Is there a 'sent' list/history of the 'alert someone' automations for a sheet? From what I can see, this information is not in the Activity Log. Thank you!
-
Summarizing items by country
Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new…
-
Formula to add into max end date
Hello! I need help with a formula when there are multiple rows of the same name with different estimated end dates - I need the furthest date to populate in the max end date column. Thanks for your help!
-
Help with Max/Collect Function
Hello! For my project, I have a database of task cards. Information for these task cards (such as Date updated, status, labor hours per skill set, etc) is input into a separate sheet, which is collected and fed into my main database. Currently, I have a helper column that says "Is this the most recent row updated for this…
-
Blank Automation Notifications
Hello, I have a number of automated workflows setup using Dynamic Cell Data in the subject lines and message bodies. This morning I was informed that some received message with blanks were the Dynamic Cell Data should have been. Has anyone experienced this issue before? No columns had been adjusted prior to cell changes.…