-
Move row automation with a full destination sheet
Can anyone advise what happens when you have move row automation running but your destination sheet is full? I assume the workflow stops until a new destination sheet is added in the automation logic? Many thanks!
-
How can I use IF to get a % in the topmost row in a hierarchy?
The issue is that of the 4 lines there are two options based on level of completeness. I've come up with this, but it's not working. =IF(Status4 = "In Process", "10%", IF(Status4 = "Complete", "20%", IF(Status5 = โIn Processโ, โ30%โ, IF(Status5 = โCompleteโ, โ60%โ, IF(Status6 = โIn Processโ, โ70%โ, IF(Status6 = โCompleteโ,โฆ
-
Mapping values in a multiselect field
I have a form that gets submitted with a multiselect field, and I want to map the values in that multiselect to other values in a mapping sheet. So if a user submits the form with 'San Fransisco, Paris', the formula would return 'USA, France' based on the mapping table on the lefthand side of my screenshot below. What isโฆ
-
Unique Variable for JOIN function
Hi All, I am attempting to use CONTAINS in tandem with JOIN(COLLECT()) to populate courses employees must take based on the care-area in which they work. In the below example, the contents of 14A are also being pulled into 4A since they both contain "4A". Is there a way to search for 4A as an absolute? (Unfortunately, I amโฆ
-
Counting rows from a certain date
Trying to create a formula to count rows that are from certain date onward (ie. 11/30/2020)
-
formula question
we are using smartsheet to keep track of community park passes. i have a column for name, account #, tag # and pass #. I need to be notified / alerted if an account gets more than one pass. Is there a formula that can check for a duplicate account number when the pass # cell is not blank? In the below picture, I sorted byโฆ
-
SUMIFS AND Formula Help
Hello, I am attempting to calculate the sum of a PRICE column, if the COLOR column=BLUE AND the FABRIC column=TW100. If I type =SUMIFS(PRICE, FABRIC, Fabric@row, COLOR, Color@row) it calculates the total for ALL rows in sheet including a BLUE color, even if the FABRIC is not TW100. I need a formula which will onlyโฆ
-
If / then statements with subtraction problem
Hello everyone, I was hoping some of the pro's on here could help me figure something out. I'm creating a hours tracker for employees to use remotely and I need to calculate the overtime hours as anything over 8 or anything over 10 depending on the answer given in a column. So if [certified] = "Yes" then subtract 8 fromโฆ
-
Formula
I am trying to add a metric on a sheet summary for campaign tracking that pulls from two options on a column dropdown. Option A is campaigns that are โIn Developmentโ and the other is โIn-Marketโ. I want to get the average in another column that is โdurationโ of days for campaigns that are โIn Developmentโ and not โInโฆ
-
Average(Collect with OR Function
Hi there, I am trying to average a subset of items based on multiple criteria: Intent is to average the score if the following criteria apply: *Period equals review period selected in absolute cell reference *Analyst equals analyst in that row *and the function includes TM-CRNI, TM-CARFI, FIG-CRNI, FIG-CARFI, or Accountโฆ