-
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…
-
Allocated Time % versus Duration
Can anyone tell me the correlation between Allocated Time % versus task duration? If I estimate that a task will take 2 days (16 working hours) to complete but then assign someone to it that only can work on it 50% of the time, why will the system automatically create a start and end dates that are consecutive days? Since…
-
Creating a Formula to track inventory
Hi All, i am trying to track inventory and alert appropriate personnel of when they should order more parts according to lead time. For the most part everything is working well. However, when parts come into the building and are added to inventory my formula still deducts anything that was sent previously. i am assuming…