Hi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the creator of the plan would have a business license. Many thanks.
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
I'm a facilities project manager at an educational institution. We have begun using smartsheet for our project management tracking. I'm wondering if anyone has developed a pay application sheet they use in their applications. I think I could probably build one that will work but no need to reinvent the wheel if one already…
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
This discussion has been merged.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…
Hi All! Thank you for your help in answering my question : ) I am wondering if there is a way to have a column filled with dates on one Smartsheet. And if the date is filled on this Smartsheet, have it presented as a checked box on a new Smartsheet. Essentiallly rather than our executive team looking at a bunch of dates…
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?
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?