Hi there! I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just …
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the p…
Can anyone suggest what is wrong with my formula? I get an #INVALID OPERATION result. I've looked at it for too long and can't find the issue. Thanks. =IF(NOT(ISBLANK([Order Date]1)), "Ordered", IF([R…
We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end …
When exporting a sheet that uses status symbols (such as the RYG status balls) to Excel, the symbols/graphics do not convert, only the words. How can I change this on the Excel document?
My company has recently started using Smartsheet. We are a pool renovation company and each job is being set up as a separate project. We've been using appsheet for about 9 months now and want to inco…
Current project settings allow to set-up working/non-working days and length of day in hours globally per project (see screenshot) We have teams from different continents and countries (US, India, Chi…
I'm trying to find the best/easiest way to display data from a Sheet Summary Report into a visual Dashboard. We have 6 different project teams, each with multiple tasks or projects with criteria we ne…
Hello, I am relatively new to Smartsheet and am interested in hearing how folks are utilizing Smartsheet’s Meeting Management template set. My organization is looking at potentially using the meeting …
