-
Help! Trying to edit the automation of RYG balls!
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 show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…
-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have…
-
Fleet maintenance template
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 someone must have already done something similar with smart sheet - any help gladly received. Andrew
-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Sending Email as an Attachment
I have an email scheduled to send a sheet as attachment. I've selected excel as the document type, however after I add the schedule, it changes back to PDF and when it sends it goes as PDF. How do you make it stay with excel as the document type?
-
Report - Not all Sheets Displaying
Hi. I've set up my first report to show tasks from multiple sheets with a date parameter. Only one sheet of tasks is showing. Wondering if there is an error of some sort in the sheets that are not displaying in the report. Thank you.
-
Countifs Issues with Date Columns
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 next 30 days. Both columns have conditional formatting associated with them, but the one giving me heartburn has the date…
-
Autofill is working on some formulae in a row and not others
We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermittent behaviour that is most troubling. Sometimes, just sometimes, when we insert a new row or add a new row at the end of the…
-
Can cell data create a row?
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. I would like to use a modified version of the Agenda Item Follow Up template to turn any of those agenda items (from Meeting…
-
Using formula in a Date column, then using SUMIF to total
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 'Personnel Discipline' or 'Equipment Item' to forecast, they then will enter the start and end date and the quantity…
