Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will s…
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure …
I am having issues with a formula that I try an use to count dates in a column that are less than the present day. With a modification the formula works just fine count the number of dates within the …
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an '…
I am trying to build a report that shows % complete, by project, across multiple projects (eg, Proj 1 = 50%, Proj 2 = 75%, Proj 3 = 10%) in one report view/summary. To date all I have been able to do …
Hi to all, I need to add a % Planned to my plan. I used a formula but it didn't work. Attached you have a screenshot of my plan with the formula and the dates columns. Thanks for your advice!! Adelina…
Is there a way to find all reports that use a particular sheet as source data? We have one giant sheet that is the mother of all our sheets, and we plan to make substantial changes to it but first wan…
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original lis…
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations…