-
Invalid Workflow - need help in resolving issue
I have an intake sheet where entries are added needing approval. I have a column set by a formula that looks up the type of request to determine the number of approvals needed. I was trying to send out the approvals right away but the formula wasn't resolving fast enough so I now have another workflow that sest a column…
-
Reporting on impact of changing a start or end date
I have a sheet with ~1000 tasks that make up my project plan. The tasks are defined for several different teams and there are a lot of dependencies between tasks. I created two sets of Start/End dates. The primary start/end dates I keep locked so that only I edit them and I have a dummy start/end date that I allow the…
-
Automated update after an automated report has already sent
Hi Community, I have set up some automations for my PM team where every Thursday, each one of them receives an update request to give a weekly status update on their projects. When they submit their updates, it populates to specific columns on a master Smartsheet depending on date of submission. This sheet stores all…
-
Proactive with Error Messages - Report
Is there a way I can be proactive about error messages that apprear on my various sheets, reports and dashboards? Like provide me some type of report, so I can go to those pages and get things fixed? I would not even know how to set anything up, as there are multiple sheets, reports, dashboards I manage.
-
Smartsheet for tracking Business Licenses?
Hello, I am looking for a Smartsheet template to help manage and track business licenses for our 200+ restaurant locations. These are health licenses, business licenses, etc. which expire annually and need to be renewed. Looking to track by location, and also set up alerts for renewal dates.
-
Cell linking not working for multiple numbers
Hi all, My cell linking is inconsistent and only works for one or two of my req #'s, see below pics: It's taking the info from this sheet and linking it via the REQ #'s onto my other sheet: Any ideas why it wouldn't be populating the date into the barging details column like it does when i only have 1 or 2 REQ #'s? Thank…
-
RM API Latency / Inconsistent Results
Has anyone else noticed poor performance and/or data inconsistency with the Resource Management API in the last 48 hours? I see the documentation site was updated yesterday - did anything change with the API itself? We have a weekly timesheet integration process that relies on the Resource Management time entries endpoint…
-
Exporting Email Addresses from Smartsheet Contact List for SharePoint Integration
I have a Contact List column in my Smartsheet, but when I export the sheet to Excel, it only displays the full names of the contacts. For my SharePoint migration process, I need to retrieve and export only the email addresses from this column to ensure seamless item creation in the SharePoint list. I'm looking for the best…
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
Copy of Submission Not Showing All Columns
Does Smartsheet show all columns in the "send me a copy of my response" email from submitting a form? We used to show a critical piece of data in that our submitters would use for their records but now that column no longer appears in that email. The column used to display in the email, and has not been adjusted since the…