-
Capturing Training Completion
We are looking for an easy way to track attendance and completion for a list of trainings. Ideally, we want each person attending a training to be able to check in themselves and mark when they’ve completed a specific course. We would need to track each user. They could enter their name, and we would time-stamp the record.…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Resource Management Calculation
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
-
Has anyone used remote staffing (like CrewBloom) to support Smartsheet workflows?
Has anyone here used remote staffing support (like CrewBloom) to help manage Smartsheet projects more efficiently?
-
MM/DD/YYYY Date Format
Can we please add a MM/DD/YYYY date format to Smartsheet? I would like to feed this date into some DocuSign forms I need employees to complete, but they require a MM/DD/YYYY format in order for me to be able to utilize these dates.
-
Updating of cells from an approval form submission
I have a sheet of users listed and a field to confirm if they are enabled or disabled. Then I have a second sheet populated from a form, where users submit a request to have access enabled. this uses an automated function to send an approval email to the manager who approves or rejects. What I would like to do is use this…
-
Automation for Daily Reminders After X Days Past Due
I'm creating an offboarding checklist sheet which sends out automation notifications to relevant parties in each department. Notifications are sent out when the termination goes live, one week after the termination date (if that department's tasks still aren't checked off as done), and two weeks after the termination date…
-
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
-
Automation to Auto-Collapse a Row
It would be great if you could set up an automation to auto-collapse a row based on a status or a date that is in the past. I use a grid and calendar to breakdown payroll deadlines and reminders for a whole year and the sheet can get pretty big so having a rule that will auto-collapse rows when something is completed or…
-
#INVALID DATA TYPE on an IF( function
I have a formula that I'm trying to get to solve the following situation: If someone has worked for less than 2 years (<730 days), the "destroy on" date should be their hire date plus 3 years (ex. hired on 1/13/2021, destroy on 1/13/2024). If someone has worked for 2 or more years (730+ days), the "destroy on" date should…