-
Question: Formula results in reports
Hi! We use formulas in sheets. When will the calculation be done? Ony when having a sheet open? Or also when using the column in a report? In other words: If the formular uses TODAY or s.th. like that, the result differs from day to day. But is the result okay, when the sheet hasn´t been opened for a few days, but used in…
-
If NOT complete, change end date to TODAY()
Hi I'm trying to automatically increase the finish dates of tasks not completed, that were due for completion before today, to today. Is there any way to do that? Any help would be really useful
-
Use formulas in percent complete column with dependencies enabled
I have a formula in my percent complete column, but when I enable dependencies (in my predecessor column and duration column) the formula gets wiped, leaving only the value behind. Is there a way to keep the formula when enabling dependencies or is this just a limitation of smartsheet?
-
How do I auto check a box based on a date + x # of days?
Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick…
-
Modified Date by Cell not row
Hi, I have a use case where I need to apply current date when a specific cell is modified--not the entire row. I understand there is cell history, but need this cell modified date visible as a value in the sheet. Thoughts? Thanks, Sean
-
Organize formulas on a sheet
Hi I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want. So question is how best to organise formulas on a sheet, is the below…
-
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
-
Formula placement where data rows are constantly changing
Hi All, I am trying to build a report or sight that captures the count of various columns based on other columns. {PLEASE add the funciontality of formulas referencing other sheets}. The count and countifs formulas work well in isolation. I can add the formula in a new column and then hide this column. The problem I have…
-
Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
-
IF formula with dates
Hi Can anyone assist with why this formula doesn't work? Ideally I would like to return a text result of "FY18" if the dates are in the range 01/07/17 to 30/6/18. Thanks in advance. Richaerd