-
Countm Distinct formula for multiple dropdown column
When I use the countm(distinct()) formula, I get an answer of 4 instead of 3. This is a drop-down list with the option of having multiple values per cell. There are no extra spaces in my cells. The formula seems to know that there are 3 different options in the blue highlighted cell but is unable to see that the "K-S-212"…
-
Linking Two Sheets to update dynamically When columns are added and removed.
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on…
-
Reference Sheet Summary data from another sheet
Currently if I could like to reference another sheet in either a cell or in a formula elsewhere, that data must come from a sheet and not a sheet summary. This means I have some data duplicated in a sheet summary for a report, and also in a sheet for use in a reference elsewhere
-
Use a formula to change the row's health
In a schedule, I'm trying to change the row's health to "red" when the current date is past the "Finish" date and the task is less then 100% complete. I can't get the formula to work when I try to make use of the "% Complete" column. Here is what I'm trying: =IF(AND(Finish@row < TODAY(), [% Complete]@row <> "100"), "Red",…
-
Combine data from multiple columns, unless data is the same
Hello Smartsheet Community! We have (2) sets of columns of data that pull in data from (2) other sheets for Ship Dates, Tracking, Order Numbers, etc. Sometimes both sets of columns will be populated sometimes just one column will be populated. We are currently using the JOIN function to combine the data from a set of (2)…
-
How to prepopulate a form using the row as a reference?
Hello, I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have…
-
IF CONTAIN formula - Email Validation
I'm attempting what I'd consider a pretty basic IF CONTAINS formula, but I'm not getting the results I'm expecting. As an attempt to validate emails, I'm trying to use IF CONTAINS to turn on a flag when .com is not found in the email cell. "Your email" field contains email, which in input by the user via form. "NEEDS…
-
Smartsheet formula to only apply to Parent Tasks with specific criteria
Hello, I have been using Smartsheet for a few months but am definitely still considered a beginner. So far, I've gotten by fairly well thanks to this forum :) I am using the following formula which calculates the % of child tasks which are Complete, and it only applies to Parent tasks. This is great, but I only want it to…
-
=COUNT(DISTINCT(COLLECT
Hi, i am using the "DISTINCT" value in a formula which works great however is there a way to not count entries twice based on if its submitted as capital or lower case, for instance 'Fred' & 'fred' are counted as two unique names when in fact i only want it counted once? Cheers Shaun
-
Assign an "item" to a new owner and delete the same item from other "owners/cells"
how i can do it, assign an "item" to a new owner and delete the same item from other "owners/cells", in an automated way, or in anothers words, there two conditions: -assign "equip" column to "owner" column -delete the same "item" from other cells in the "item" column example> i really appreciate any help.
