Trending in Formulas and Functions
-
Dividing to Create a %
I would like to use the data in Column A and B to create a percentage complete by row NOT by parent/hierarchy. In Excel this would be =sum(Column B/Column A) = %. What is the formula for Smartsheet?
-
Looking to Countif a person's name is contained in a column that allows for multiple contacts.
=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count…
-
Replace Multiple Values with Multiple Values
I have a Status column which is a dropdown list. I would like a formula that checks the Status column and returns a different number for each item in the list. Any suggestions on how to do this? STATUS. RETURNED VALUE "NA". "1" "Not Started". "2" "Priors Pending" "3" and so forth.....