-
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
-
Count specific list items in child
I have a list of reports being sent to specific users as seen here: Location 1 - User 1 xxxxxx -- Report 1 Monday -- Report 2 Thursday -- Report 3 Daily In the "xxxxxxx" cell, I'd like something like this: M:2 T:0 W:0 T:2 F:0 to let me know at a glance how many reports someone is getting on daily basis. I can't spread the…
-
Help with an IF statement
Hi guys, I'm in need of some help with regards to trying to use an IF statement to manage Priority rankings. Basically, i have two columns that rank boht Criticality and Manageability, dependant on the score obtained across boht of these dictates the Priority ranking applied to a Risk. I'm currently receiving an #INVALID…
-
Report based calculations
I would like to be able to have a calculation take place in a report that is based on numbers in cells from two different spreadsheets. Any ideas? Not keen on linking for this application as that would require multiple linking of new data, which would have a higher probability of user error.
-
Date Formula Help
Can someone share with me the work around they are using for the following issue? Example Start Date 08/01/14 Time I want to add to this date - 14 months Fomula I want to use =DATE(year(08/01/14),month(08/01/14) + 14, day(08/01/14)) Which returns an error because the month value is > 12. In excel it just adds 14 months…
-
Append Text before Formula
I have a formula like below: =ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0) How do I append "ETA Week Number" before the result of the formula. I have tried the below, but it comes up as UNPARSABLE =“ETA Week Number “ + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
-
Reference a row by Task Name instead of by the row Number.
Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number. The formula is pretty simple. I have a Completion Date column and a…
-
Recurring Reminders
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a monthly basis. Thank you.
-
Moving rows and losing formulae links.
Hi there, I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the row change. I have to reapply the formulaes in certain cells which can be time consuming. has anyone else had this problem or…
-
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!