-
IF() Statement troubles
In Excel I can use the following statement with no issue: =IF(A89="","",(WORKDAY(A89,-3,Holidays!$A$2:$A$9))) I tried the following in Smartsheet and receive the error: #BLOCKED. =IF([Launch Date]36 = "", "", (WORKDAY([To Production by 3 pm (Site merch deadline)]36, -1, $[Holidays 2016]$1:$[Holidays 2017]$13))) Any…
-
Setting the end date, durations and dependancies to find the start date
Can smartsheet be used to figure out the start date when the end-date, durations and dependancies are given?
-
How to fix a project launch date
Hello all, I have a project with a fixed launch date - what i need to know is whether i will hit that date. If i set dependencies with predessors then it moves my launch date.. but if i set the date as fixed for the launch i cant set up the dependencies on the previous actions... Am i doing it all wrong? How can i set a…
-
CardView
Can I merge more than one smartsheet into a single Card View?
-
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
-
incorporating map in smartshint printout
Is there a way to bring a smartsheet map into the sheet itself to print? It would be very useful (not to mention extremely professional looking) to be able to print the sheet with the map on one page.
-
Interconnecting sheets/data?
We are evaluating Smartsheet as a Project Management solution. I'm wondering if it's possible to have a sheet for "Client Contact List" and then a "Project Management" sheet that can reference it. For instance, could I create a column called "Contact" and select from my contacts and have it auto-populate other columns such…
-
Sorting by "start date", sorting by "assigned to"
Does anyone have recommendations for how to sort a master sheet by "start date", so that the dates are in ascending in chronological order, and also how to sort by "assigned to".
-
How do you archive Sheets without deleting them?
Hi, I was hoping that I could get some information on how I archive sheets?
-
Suggestions? How to manage/track the Smartsheet workspaces and sheets?
Our SS environment is growing rapidly. Any suggestions or tips when it comes to managing all the sheets. I'm thinking about building a sheet registration Smartsheet that captures who reuested the sheet, when, purpose, department, owner.....etc.... Has anyone done anything like this in the past? Thanks Jim
