I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?
You are correct: you cannot place a formula in the Duration column if you're using that column in your Project Settings for Duration (see: Areas where formula use is restricted). This is because the sheet already applies a background formula to that column - if you select a Start and End date, the Duration will populate based on the Working Days set in your Project Settings.
You can add another, regular column in your sheet to perform calculations and determine durations, but this column cannot then be selected in your Project Settings. Please let the Product team know of your use-case and why you would like to have formulas in this column by filling out this form, here.
I have learned that if it is not a column formula that I can select my Calculated Duration as my duration column, however, the formula gets erased at that point and it just becomes a regular duration column.
Thanks @Genevieve P. . I marked your response as not answering my question, but I guess it did: it isn't possible. I can't go back and change that because once you select one it disappears, but feel free to mark it as answered by you if you wish. I did submit feedback to the linked form.
FYI, I had a related, initial, question here:
Thank you for providing your feedback through the link! The Product team reviews each of these submissions so it's a great way to let them know how you're using Smartsheet and any enhancements that you think would help with your current set-up.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.