-
Adding IFERROR Formula
Smartsheet Community: I am Trying to Add IFERROR to The Below Formula, but Receving an Error. Current Formula: =ROUND((COUNTIFS(CHILDREN(), OR(@cell = "Pass", @cell = "Fail-4Front Review", @cell = "Fail-Shorr Review", @cell = "Re-Test Ready")) / COUNTIFS(CHILDREN(), @cell <> "")) * 100) + "%" Modified Formula withโฆ
-
Count if
I am working on getting my Metric set up I want to count if Project is PMO or CI and In progress, Not started ect , from my sheet called Project in take
-
Refer to a date and return the fiscal year
Hello, Looking for some assistance with a formula that refers to a column (DOS) and depending upon the date range it falls into, it returns the fiscal year. I'm using IF and I'm getting #unparsable so I don't have it written properly. =IF(DOS@row > DATE(2022,6,30), โFY22โ, โXโ)
-
How to return the date of a specific day of the month?
We have a calendar that has tasks that occur every Sunday of the month. We would like to be able to set the first day of the month and have each start day return the 1st Sunday of the month, the 2nd Sunday of the month, etc. And we would also like to be able to edit this formula for each day of the week. Not sure where toโฆ
-
Link two cells
Hello everyone, I'm new working with smartsheet and seeing that he does not have all excels formulas. I need to change a "status" when I change a number in a column. For example, when I change the column "Status da entrega" to "Aprovada", the next line change "Status da atividade" to "Liberado" and it is working fine withโฆ
-
How to interchange one cell value with another cell value in the same sheet.
I have 2 sheets 1st is Asset Master sheet and 2nd is Material Movement sheet. Once I received a new cell value from Current Location Final which is populated from Material Movement sheet. I want to interchange the cell value in "Current location Final" to "Current location" in Asset Master sheet. For e.g. After using theโฆ
-
SUMIF and Child rows
This discussion was created from comments split from: Can I use a SUMIF formula to sum children rows?.
-
How to populate unique identifier created through form submission on one sheet to other sheets?
Apologies if I'm repeating a question but I have not seen an answer. We have a Master sheet that users are inputting data through forms. Included is an auto generated unique identifier. We are also using the workflow automation to copy the entire row to separate sheets based on conditions. How can we populate specificโฆ
-
Why is JOIN assembling items out of order?
I have two columns, "Ovrst" and "Gov" with the same formula for different input column ranges. Both are multi-select columns. I'm joining values from their respective columns & cells into a single cell. Even though the JOIN function lists the cells in numerical order (top to bottom - 18-27), the resulting JOIN value hasโฆ
-
Multiple % Complete Columns?
Hi all, Overview: I'm looking for a way to have more than 1 '% complete' column in a sheet Application: I'm building a project compliance matrix which will have a row for each requirement, and multiple columns for associated tasks. I'm not using this as a schedule / GANTT, but have turned on dependencies as this allowed meโฆ