Formulas and Functions
Archives for June 2018
Discussion List
-
Elapsed time - 24hr workday - Display bug?In Formulas and FunctionsSee the attached pic. * The sheet is set for 24hr workdays. Mon-Fri. * There are 2 tasks. one with duration 7d and one with duration e7d. * The e7d task does not display 7 days of working. The gantt chart bar does not show sun…
-
COUNTIF FunctionIn Formulas and FunctionsI'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:St…
-
Copying formula across columnsIn Formulas and FunctionsHi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMI…
-
Count number of days between two dates and return the difference and if early or late?In Formulas and FunctionsHi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date…
-
"If clause" in DependanciesIn Formulas and FunctionsHi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet…
-
COUNTIF FunctionIn Formulas and FunctionsIm trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types) I have these formuals but its not producing a result * =C…
-
validating cell valueIn Formulas and FunctionsHi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
-
Auto Downfill?In Formulas and FunctionsIs there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said f…
-
Formula helpIn Formulas and FunctionsHello, I am trying to do a vlookup on my smartsheet task list to reference a different smartsheet which looks up for example "312" returns the value two columns over, which is a date, and then minus 90 days from that date and ret…
-
Nested IF and OR (and possibly AND)In Formulas and FunctionsHello, I have two checkbox columns: one for Arabic and one for English. These columns will either be checked, unchecked or say "n/a". What I want is to have another checkbox column where it is checked if Arabic and English are…
