-
Merged: Data Validation Dropdown Lists - Simple Feature
This discussion has been merged.
-
Total number of days a resource has been allocated
I’m working on a project with multi resources. Is it possible to run a report that shows the total number of days a resource has been allocated? So, I can calculate the work effort against a resources? Thank you
-
'Current User' default in web form
Hi, Is there a way to set a web form field to default 'Current User'? Like we can pre-filter a report for example. Cheers, Rick
-
IF, AND/OR, NOT formula with multiple conditions for a symbol column
Hello, I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")) However, I need to update this formula to include criteria that states NOT if the Phase@row is…
-
Control Center Automation Ability to Trigger Document Sets Specific to Project Category
We would like the ability for Control Center automation to be configurable to trigger different document sets based on the category selected in the project intake sheet. For instance, if the new project request is Category 1, we would like to trigger a set of reports and sheets specific to Category 1. If the new project…
-
Programme Status based on %complete
Hi There, Apologies if this has been addressed elsewhere, I could not find anything similar. Are you able to status update a programme so to update % complete and the resequence the programme task to start after the today line?
-
Parent Row showing on multiple rows in a report
Hi, I'm currently using a sheet with information about different projects and need to show a Parent Row on all the other different "statuses" assigned to different Subtasks of that same project, I already have a formula to show the Parent based on their children, but I would appreciate any help on this issue. Attached…
-
Project Sheet - Static Finish Date
I didn't see a post about this yet, please post a link if this is a repeat issue! It seems like the default relationship between Duration, Start, and Finish is that when you update the finish date or the duration, the start date is kept static, the duration gets extended and the finish date gets pushed out. Is there a way…
-
RFI Request for Information Template - can not find
I found the RFI Request for Information Template that I loved on Google so I signed up for a Smart Sheet account. Im logged in and search for RFI Request for Information Template- the search result is a "Status View Smart Sheet" not a RFI Template. See screen shot. Here is a link to reference page to RFI Request for…
-
Can I alter this formula to generate a date based off a deadline of the 4th Friday of every month?
As a form submits answers to my Smartsheet, the submission date is recorded under a column titled "Created." This information is submitted to a committee meeting on the 3rd Wednesday of every month, so I needed this formula to specify at which meeting date each response row will be considered. I found the formula below on…