- Connecting ADP to Smartsheet
Hello everyone! I have a goal of integrating ADP with our Smartsheet platform to create comprehensive dashboards. The primary focus of these dashboards will be on the following key areas: Tracking Hours: I want to establish a seamless connection between ADP and Smartsheet to effectively monitor and manage employee working…
- Connecting to Amazon QuickSight
Hello, we currently utilize amazon QuickSight to build automated dashboards from other websites. Would it be possible to connect the data collected on Smartsheet to build automated dashboards on QuickSight?
- Create cross sheet references to work with data in another sheet
I have five individual columns that I would like to cross-reference with another sheet on Smartsheet to get specific information. For example, In Smartsheet A: I'm collecting data on when front-line staff call in absent, each employee can get a drop-down menu to get to the specifics of why they're unable to attend work.…
- Count the number of submissions in a particular year
How can I do a Countif Formula that would collect the employee payroll number and count how many times an agent has been absent for ONLY 2023. One issue I'm having is collecting previous years, such as 2022. I only want it to count as 2023.
- Formula Help
Hello, I'm trying to create an inventory of all the items we currently have in our uniform room. The first column will have POLO Shirts USED through the year, the second column I would like to have our current stock inventory inside the room.. the third column will indicate if it was either provided to a staff member or…
- HELP: Formula for Dashboard
Hello, I've currently built a form that allows people to Check-In and Check-Out, which then they'll have a drop-down and select their name. I've also built an automated dashboard which will indicate how many people are currently checked IN in each area. Some of our staff forget to Check-Out when leaving work. How can I…
- How to send automated dashboards
Hello, I’ve created a dashboard on Smartsheet. How can I send the dashboard to clients and front line staff automatically once per day? I was sadly unsuccessful in seeing this option on the dashboard page Many thanks in advance!
- Time Indication and DATEONLY function
你好,我哈ve a few questions below regarding Smartsheet: We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete. How can I remove the time in "Created", I would only like to have the date. (photo 2) Question 1 Explanation below: I've noticed…
- Help: formula won’t apply to a new template
hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below:
- Creating Automated Emails are specific times
Hello! We've developed a form; our client would like to see it being sent to them daily at 1100am, and 0300am. Would this be possible? So far, I've gotten this far, but I believe this wouldn't work because Condition two contains "Where created today" submissions that are created at 0235 would not contain yesterday's data…
