-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…
-
Auto Fill Values based on existing values
In Excel, if you have a column that has say values such as "CAT", "HAT", "MAT"... If I am going down row-by-row and start typing "M" then this prompts you with the option of hitting enter or click to choose the work "MAT" as this already exists as a value in the column Does anything like this exist within SS?
-
Past Due Formula Help!!! - IF / AND
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would go in the "At Risk" column?
-
Have Sheets feed child rows automatically into a Master Sheet?
Forgive me if this topic has been covered before, I've done the best I can searching. So my employer wants to have our projects be listed in a sheet, each department in a different sheet and to have that information feed into a master sheet (or a couple master sheets actually). I know you can cell link one row at a time,…
-
Best practice of recording occurrences
Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes. Ultimately, it may not be achievable, but I thought I'd ask: I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards…
-
¿Automatically sum up child values into Parent Cell?
I'm looking for a solution to automatically sum up child values for selected numeric columns. There is a workaround that is to use sum(children()) formula, but I dont want to write the formula every time I add Parent rows. Any ideas? Thank you.
-
Current work filter for tasks not Complete and Due in the next 2 days or the past
I am trying to build a filter that will be utilized to Identify Current and Past due work. I can get the filter to find all not Completed or Canceled work in the Past or the Next # of days. I cannot get it to find all taskx from 2 days in the future and older. Is there a way to add a formula when using is less than or…
-
MS Project 2016
Hi All, I've just updated to MS Project 2016 and am unable to import my programmes into Smartsheet. The tasks import ok, but the duration of every task is at zero days. Urgent advice would be greatly appreciated please. Alan
-
Screen Snipping Tool
Is there any way to screen snip and have the snapshot saved as an attachment? The only way currently appears to be screen snipping and save into word and then attach or save as image and then attach that
-
Has anyone else had a problem with sheets loading slowly in chrome? I have found a solution.
I have computers that load sheets slowly and others that load instantly: I finally found out why. If anyone else is having this problem let me know.
