-
Elapsed time - 24hr workday - Display bug?
See 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 sunday as a working day. * Resource view DOES show sunday as a working day. Bug? Also, the "roll-up"…
-
COUNTIF Function
I'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:Status, "Red")
-
Copying formula across columns
Hi, 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 =SUMIF(Personnel:Personnel, "Alison Michel", [Summer 2018 - Aug]:[Summer 2018 - Aug]) to…
-
Count number of days between two dates and return the difference and if early or late?
Hi 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 (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
"If clause" in Dependancies
Hi 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 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
-
COUNTIF Function
Im 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 * =COUNTIF(Type1:Type50, "Risk", [Status1]:[Status50], "Open") * =COUNTIF(Type1:Type50,…
-
validating cell value
Hi, 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?
Is 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 formula? This can help users decrease their time entering formulas and allow ease of…
-
Formula help
Hello, 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 returns that date in the cell. Is there a way to do this?
-
Nested IF and OR (and possibly AND)
Hello, 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 both either checked or "n/a": for example: IF Arabic = 1 OR “n/a” AND IF English = 1 OR “n/a”,…