-
Resource Allocation
Greetings, I am new to the aspect of resource allocation. I need to know apart from people can objects (computers, scientific instruments etc) be allocated as resources, as I need to keep a tab on the overuse of certain equipments at my organisation. Next, can only people with licensed accounts be tracked as resources on…
-
Using Contact List Column Type in Task List Forms
I made a recurring task list based on the template Smartsheet provides. I have tasks assigned to different contacts in a contact list column, and users enter new tasks through a webform. My issue comes when they enter the "Assigned To" name. Even if they type their name EXACTLY how it is on their account and in the current…
-
Issue is not displayed in Gantt view
Hi! For some reason Smartsheet doesn't show my issues and it's estimated time in Gantt view: (see the ones in the rows 67 and 68) (Image attached below.) Maybe that's because of 2.5h estimate, but even if I change it to 2h or 1h it doen't work. Both tasks have dpendencies but Smartsheet system didnt calculate their Start…
-
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…
