-
If Cell is Empty or Blank
Hi, I have created the following formula =IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Pending") > 0, "Pending", IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Created") > 0, "Pending", IF(COUNTIF([PCORI Reports]@row, "Requested"), "Pending", "Done"))) which is working efficiently, but…
-
How do I create a automation workflow in a report?
I managed to create a workflow in a report but I am now unable to get to the existing one to edit it OR create a new one. There was a pop up that got me to the automation workflow page to create the first one but I can't get the pop up to come back or to get into an edit view. I confirmed in the activity log of the report…
-
¿Cómo encuentro el valor de auditoria diario?
Esta es mi formula: =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20") Cuenta si en columna 5 encuentra "DAL 1" Cuenta si en columna 6 encuentra "Si" Pero como hago para que busque siempre en fecha actual, es decir con alguna función today
-
More options for RAG Status
Hi, We have a requirement for additional Status options than Red, Amber, Green - I also need Blue to mark complete and Grey for not applicable. Currently, I have to choose either Blue or Grey - just wondered if this came up as a requirement for anyone else and what did you do? I still want to see the circles - so, adding…
-
'Request an update' Automation: 'Condition' where column contains a cross-sheet reference.
Will the automation “Request an update” fail if the 'Condition' column contains a cross-sheet formula that pulls data from another sheet? For example, there are two Smartsheets: Sheet ONE contains Project ID, MFG Rep and Customer Price. This is the source sheet for Project ID and MFG Rep. Sheet TWO contains Project ID, MFG…
-
What is the formula to find a criterio (Yes or Not) in a report on specific date wit rule (Today)?
I used the formula =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "Sí") to found discrepancy for all days but I want to lear how to find in a specific day "Today ever" Please help me.
-
Need help with formula for individual non-workdays
Hello, I am using the following formula in my project timeline and which references another sheet which logs any individual non-work dates. This works great in most circumstance: =IF(OR(COUNTIFS({Sheet - OneStream Non-Working Days Assigned to}, [Assigned To]@row, {Sheet - OneStream Non-Working Days Start Date}, >=[Start…
-
Can I extract the name of a column and use it in a formula?
I have a table set up with data organized by quarter (3W20, 4Q20, 1Q21, etc), and am using the quarters as the names of the columns. I have formulas in the columns that display data for that quarter, but I've had to manually type in things like "3Q20" in my SUMIFS formula for one of the criteria. Is there a way to pull out…
-
INDEX, MATCH and COUNTIF function are not working
hi there, I have a trouble on the below formula. The same formula works well on Excel, Col F could return the non duplicate items. But on smartsheet, only first item (i.e. a) could return. Could someone help me? Thank You =INDEX($A$2:$A$20,MATCH(0,COUNTIF($F$1:F1,$A$2:$A$20),0 ))
-
Is there a way to mass update a drop down list from an upload file?
Hi There, Is there a way to mass update a drop down list with an upload file?