-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
Return value at the intersection of a row and column
I am new to smartsheet and haven't found what I'm looking for through search. I have a sheet that is contains a table of cycle times. This table is for reference and the values in the table will be used in a different sheet. I want to be able to return the value that is at the intersection of a row and column based on two…
-
Child statuses in parent row- combined from more than 1
Hi Smartsheet Heads! Currently I am using a formula from this thread: https://quip.com/nyDjAzhAKRhq =IF(COUNT(CHILDREN([Localisation Status]@row)) > 0, IF(COUNTIF(CHILDREN([Localisation Status]@row), "Approved") = COUNT(CHILDREN([Localisation Status]@row)), "Approved", IF(COUNTIF(CHILDREN([Localisation Status]@row), "Not…
-
Is this a Bug or a Feature?
Hi There, Trying to figure out if you have a column set to dropdown and allow multiple values per cell, when you go to create an automation for it, is it suppose to only let put it in as a if it changes only?: why isn't it like a dropdown without the allow multiple values per cell on: why can't I select a value in the…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
-
Count and Occurrence of Duplicates in a Column
I'm trying to count the number of duplicates in a column and then number those duplicates in another column. For example: I'm using the formula COUNTIF([Legacy ID]:[Legacy ID], [Legacy ID]@row) in the Multiples column to count the number of duplicates in the Legacy ID column. I need help with a formula to create the MCount…
-
Using Zapier to Create New Sheet with Automated Workflows
Hi, I'm trying to use Zapier to create a new sheet in Smartsheet from a SS template I made. All wen't through fine, but unfortunately it won't copy the Automated Workflows I had set up in the template. So as far as I can tell, Zapier won't copy automated workflows - has anybody come up against this issue, and any…
-
COUNTIF AND for data in 2 columns
I have 5 different locations and 10 different types of devices in 2 different columns of my spreadsheet. I need get a couple of devices in each of the different locations (i.e. I have 40 various devices in 5 locations - I need to know how many of each device is in each location). That's an example, there are actually…
-
Alerts when X ammounts of items arrive for project X
Backround: I work with custom computers, its only me myself and i in my department so i am looking to automate as much as possible. I have a sheet where i enter every part that arrives and which Project number it belongs to, what Serial number the part has and the parts EAN code. Goal: I would love if i could set up a…
-
How to show # Days Overdue only if the task is not complete
Hello Community, So I have a sheet with different columns I am using three columns % Complete, End Date and # Days Overdue I want the # Days Overdue Column to show the number of days the task is overdue only if the task is not complete i.e. the % is less than 100% The current formula I am using is =IF([% Complete]@row =…