-
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…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Task completion (%)
Hello everyone, is there a way to set the % complete based on the task status? I have a table [state ; % complete] I tried with "VLOOKUP" function but isn't possible to insert formulas in the field. Help me please! Thanks
-
Automatically assign project requestor to the workspace
As of now it is only possible to assign a group of users to the blueprint of whenever a new workspace gets created for a new project. My idea is that there would be a possibility to automatically include the requestor of the project to the workspace, instead of the whole group. Perhaps it could be as follow: User requests…
-
Merged: Easily create recurring tasks
This discussion has been merged.
-
Task hours spread over a week
We work in a digital marketing agency; with individuals working on multiple tasks across multiple days. How can we spread an 8 hour task over a 5 day week without restricting the task to one day and without creating 5 smaller tasks for each day (as priorities may need to change due to emergency escalations) For example:…
-
How do I make my Smartsheet columns update when I update the Form
I'm brand new to Smartsheet Forms and I'm on deadline. I accidentally created a Form tied to the wrong Sheet. After realizing my mistake, I duplicated the original sheet and fixed the new column headers (which had populated when I created the Form, of course!) and went back to the original incorrect Sheet ... I THINK it's…
-
Merged: More flexible Gantt and Timelines
This discussion has been merged.
-
Duration Including Weekends
Hello! We have our project (task tracker) set to exclude weekends, which is what we need as we don't want anything due on the weekend. However, we need a duration column that includes all days between the start and end date, not just the business days. How can I do this? It's currently showing the duration of business days…
-
Float between task and it's successor
Hi, There doesn't seem to be any clear way to calculate the float between two tasks. If I have task A and task B, and task A is a predecessor to task B, I'm looking for a formula to calculate the amount of time task A can be delayed. Has anyone found a method to do this? TOTALFLOAT is not useful on my projects, it often…
