-
card view filter - include summary tasks
I commonly have task lists that are nested to an arbitrary number of levels. In card view, you can filter tasks to level 1, level 2, etc. This isn't very useful to me. I think it would be far more useful to have a filter "include summary tasks (or not)". Since my actual tasks are always on leaf nodes of the hierarchy, by…
-
Changing column Property Status (Red, Yellow, Green) when two columns dates are different
I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.…
-
"SUMIFS=" " Circular Reference Error"
Hello, I figured out how to make work a large formula for =Sumifs. The idea was to add the "target budget" of all projects that would have as Project Manager (PM/RI) "Mari M." and only for the projects that would have an "Status of Request" of ( New, Work in Progress, In Design, In construction, Substantially completed,…
-
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…
-
time calculation
Hi there, I am a newby here and I must say that smartsheet looks good. The only thing I am definetly missing is a way to calculate time This is what I need to show: Start End Duration h Price per hour Price total 09:00 10:30 1,5 100,00 150,00 Start and End time can be put in manually Duration must be calculated…
-
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…
-
Multiple Check Boxes in Cross-Referenced IF Statement
I have a master spreadsheet that details the progress of a project. I'm in the process of rolling all the information on that sheet into another that consolidates anywhere from 1-100 lines (check boxes) into a single line. The example below shows an example of 3 check boxes. That being said, I'm creating a formula for a…
-
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
-
Dashboards
We are trying to integrate a dashboard into several of our project sheets in order to get an overview of each projects health in one area for a quick reference. My problem is that i am using a prefabricated set provided by smartsheets and the "Sheet one" and "Sheet two" portions will not pull from the information that im…
-
Read receipt
Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?