-
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!
-
If And Formula Help
Hi I am a new user of smartsheet. I need help on why this excel formual will not work. I get #UNPARSEABLE =IF(([Total Billed]40)<10000,0, IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([GP Amount]40*5%, IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%, IF(AND(([Total…
-
Formula Help with NA
I need help with a formula. I have 3 date columns. If there's a date in datecol1, and a date in datecol2, and either a date or NA in datecol3, then enter 1 in col 4. I am not a programmer, but can usually figure it out. Not this time! This is what is in col 4 cell, but I get Unparseable. =IF(ISDATE([datecol1]7),…
