-
Using SumIfs to search for a text string
I'm basically trying to search for X text within my Email column to average out the monthly data. Can someone please advise what i'm missing cause it's driving me insane, haha. I know it's gotta be something simple.
-
Link to a Google Drive Sheet from a Dashboard
While I have tried everything, it seems, whenever I click on my newly-created dashboard item that links to a Google Drive Sheet (Google Sheet), it is asking users to "open with?" Is there a way I can have users click my link and go directly to the interactive sheet without choosing anything?
-
Dashboard - How to create a metric that will display a Count of data in a column?
Good Afternoon, I am new to dashboards. I am trying to use an existing Smartsheet with data and would like the dashboard to display a count of how many individuals are listed in column 1 on the sheet. Is this possible and if yes, how do I set it up? Do I have to have the count built into the sheet for it to display on the…
-
Holidays for 2019 not working
The holidays that I have entered for 2018 have always worked fine in calculating durations for tasks. As I program tasks for 2019, I am noticing that the holidays are not being accounted for. Christmas (12/24 and 12/25) for 2018 work fine, but after that they are no longer accounted for. Here is the list of dates that I…
-
Emailing Alerts & Reminders vs a notification in smartsheet
With the new Automation, I am a bit confused. When I am setting up alerts and/or reminders how do I know if I am setting it up to have the person emailed or to have them get a notification within smartsheet? My preference is for people to just get a notification is smartsheet, but I seem to be sending people emails. Ay…
-
Conditional Notification on two Predecessors
I want to set up a notification to begin a task when the predecessors of the task are completed. The tasks in question have two predecessors each and I cannot for the life of me figure out a way to have the completion of those predecessors trigger an alert to the people assigned to the tasks so that they can begin work.
-
Linked Sheets for Templates
I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here. I am creating project templates in smartsheets for our project managers. I am doing this by creating a 'Master'…
-
Send update request for all tasks not done for each assigned to user
I would like to send out a weekly update request for all "not done" tasks in a sheet, to all the users in the "assigned to" field. I can see how to easily do this with a workflow, but its sending all the "not done" tasks to the users. I want it to send only the task update requests for the tasks that that user is the…
-
Populate data from notification center
I have created a form for one of my sheets, I am fine in getting alert when rows are added or changed. Can I crete a field on the notification and select the input data from the contact list? And the data I input will directly populate the sheet itself. I would like to add an extra field for the contact list. After I…
-
Report Widget "Edit Interaction"
I'm having an issue with the "Edit Inteaction" button on a Report Widget. I select "Open the source report" action and click <OK>. Then I click on the "X" to close and save and I get a message box "Do you want to delete unsaved changes to your form?". If you click <Cancel> it goes right back to the Report Widget form. If…
