-
Automated - Otherwise - etc
I have three sets of dates in a worksheet. Initial Date, Completion Date and Closure Date. The Completion Date is often missed by personnel skipping steps, so i have added an "otherwise" condition with a Request an Update for this date. The initial condition is that this field must be filled in PRIOR to closure. But once…
-
SUMIFS Based on Parent and Children Criteria
Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a two step SUMIFS that I can't seem to get straight. It would need to be a sum "grand total count", if hierarchy 0 month = specified month and hierarchy 1 matches…
-
Multiple Installation Dates to show on Calendar
Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have Part A Date, Duration and a installer. Same with Part B. The Installer is conditional formatted as a colour to show up in…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Templates and conditional formatting
I have created a Project Schedule Template that has all my conditional formatting included. However, when I import in a schedule from Microsoft Project the conditional formatting not longer exist? Obviously, I am doing something wrong? If you can lend any advice, it would be appreciated. Best Regards,
-
Formatting varies in percent complete column
For some tasks, the parent shows a percentage (e.g. 5%), others just a number (e.g. 0.9) (see attached). If I add new rows, the % shows, but I see no method to change the format of the non-% ones. Any ideas please.
-
Subtracting dates
I have an excel sheet that subtracts dates. The formula is as follows: =IF(P4="","",NETWORKDAYS(P4,Q4)-SIGN(NETWORKDAYS(P4,Q4))) This formula works. When I use it in Smartsheets, the formula is as follows. =IF([POC Date (Planned)]3="","",NETWORKDAYS([POC Date (Planned)]3,[Actual/Pending Date]3-SIGN(NETWORKDAYS([POC Date…
-
Importing excel IF/And statments to Smartsheets
I use the below IF/AND statement in excel. It works fine. =IF(O4="Close","",IF(D4="","",IF(AND(M4>0,M4<=0.1),"YELLOW",IF(AND(M4<=0,M4>-0.1),"GREEN",IF(M4<-0.1,"PURPLE",IF(M4>0.1,"RED",)))))) When I import it into Smartsheets, the formula is below and doesn't work. I get #UNPARSEABLE in the cell. Does anybody know why the…
-
Formula to determine row number
Hello, I am wondering if there is a way to determine the row number of a specific row. I know this can be done in Excel with the row() function. This does not work in Smartsheet. The reason I am looking for it is because I have a formula that needs to apply to every row that checks the row above it, but that fails when it…
-
Trigger notifications based on dates previously input
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…