-
IF formula doesn't work?
Hello, I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below: the formula I am use is: =IF([column 1]@row >= 6500, "6,500", [column 1]@row) so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500…
-
Trying to evaluate multiple columns with an IF statement
I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny" if the status of the risk is "closed" and if not closed, i am using the other icons based on the level of the risk. here is the formula: =IF([Status]@row = “Closed”, “sunny”, IF([Risk Score]@row <=…
-
How to Join values from a reference sheet based on selections in a multi-select dropdown
Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell. In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column…
-
#invalid column value for some rows
hello, hoping someone can help me out. i want to have the overall health of each workstream calculated based on the status in the following arguments If values are greater than 0 for 'in progress' or 'complete' --> Green Circle if 'complete' equals 'total' --> Blue circle if 'not started' equals 'total' --> 'not started'…
-
Pasting formulas from a plain text document causing #Unparseable Error
Hello all, I am building a complex multilingual sheet that will be creating various documents using Document Builder depending on the user's choice of country and language. There are a lot of column formulas that are very similar but use different languages. I am using a text editor to track the formulas but have found I…
-
Need help writing a formula
In a column titled Status, I have one status as Active 1x and the other status as Active 2x. I created a new column to show values either 1 or 2 in a cell depending on the status. I need a formula that shows - if the status is Active 1x, then the cell should show '1', and if the status is Active 2x, the cell should show…
-
Workflow question
I know there is a template to send notifications out to specific email addresses. However I am looking to send notifications out to whomever is listed in the assigned to column of a particular task and also the manager of the group. Can that be done and if so how?
-
Check the Parent Checkbox if all children are checked
Can't find a logic formula to automate a check in the Parent row checkbox column if all its Child rows' check boxes are checked.
-
Help! Formula with not blank column?
Hi SmartSheets community, I need help finishing a formula to count number of sites in a specific city/state. This is what I have so far: =COUNTIFS({Master Data Sheet City Range}, City@row, {Master Data Sheet State Range}, State@row) I want to make one other column next to column that has this formula that counts only if…
-
COUNTIFS not counting when criteria is a numeric match
I might be missing something basic about formulas, but I have a COUNTIFS formula that counts the number of rows associated with an employees ID and another criteria. It works for all employees except one, who has a numeric ID instead of text. Is this something COUNTIFS just cannot do? Formula: =COUNTIFS({employee ID on…