-
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…
-
Grid to Card View
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See attached screenshots. Ideally, I want to enter the project plan in Grid view and then have all the tasks show as cards in Card…
-
#Invalid Operation - Error
I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other. I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID OPERATION (Red Arrow) however in the 2nd Smartsheet example (Blue Arrow) the formula works In the attached I have provided…
-
Formula for a Flag Column Based an If/Or statement
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag should turn red when anything other than NA is selected. If NA is selected, then no red…