-
A resource left the business. How do we keep a track of his hours?
We've just done a reconciliation as part of an audit. We got dinged by the audit company because the hours in Resource Management don't match with the hours we billed to several clients. This took some investigation but we eventually realised that the system was not counting any of the hours logged by a Project Manager who…
-
Need the report to show all data even it is more than 2500 lines
Hi , Can Smartsheet make an open option to choose group between summary in one page or group of all data with an option to select 'next' in one report.
-
How best to share sections of a sheet
Hi, I have a training matrix that I need to make accessible in parts to people out of our smartsheet licenses. We have a matrix that identifies needs for individual teams, and we need to send each team ONLY their section, in a way that is not just viewble, but editable (they need to be able to corret if we have identified…
-
Has anyone used Smartsheet for creating training/competency matrix
Wondering if any of the community have created a training matrix for SOP training or competency levels within their organization?
-
Automated Notification to include all Contact Lists on sheet
How do we set up automation so each Contact List POC can see who else was included in an email notice? For example. when you send a notice from a row then it allows for all on the contact list to be included in email and visible to each other in TO: however when we set up the automation then it only allows for the email to…
-
Data Shuttle Automation Question
Hi, we are exploring data shuttle for a welcome kit program. Smartsheet has told me we can connect with ADP workforce now but I can't understand how automated it is. HR wants to not have to do ANYTHING. i.e. they enter a new employee's information into ADP workforce now and it automatically flows the critical info (name,…
-
COUNTIFS multiple references to another sheet
This formula gives me an error #INCORRECT ARGUMENT =COUNTIFS({Total Lot Status Global-AgingInventoryDays}, <>"", {Total Lot Status Global-New Division}, "West", {Total Lot Status Global-SalesStatus}, "Spec") If I isolate each range and criterion under a simple, COUNTIF formula, then all three criterions work fine. It's…
-
Having issue with a copy rows automation
I have a sheet with a "status column that reads "ok" when the "on hand qty" is greater than the "reOrder Point" and automatically changes to "**review and update**" when it is not. I created two automations that are triggered when a row changes and meets the condition of "status" being "**review and update**. the problem…
-
Is there a way to remove blank rows from an automated email?
I created a form, that has logistics factored into it so when one question is asked depending on the answer, a box may appear to continue down the form. When the form is submitted and i recieve the email notification, all the boxes on the form appear even if they are blank. Is it possible to adjust this so only the boxes…
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
