The ability to control text form entry against a large dataset. For example, I have a form that went out to 1,500 employees. The primary column is their name. Now when I want to check who has vs. has not completed the form, I have to manually check for false negatives due to slight differences in how they typed their name…
I am wanting a formula for new hires to be based off their hire date and to generate a date that would be 30 days after they are hired following on the 1st of the month.
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.…
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
Has anyone made an org chart in Smartsheets?
Hi! I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet. Example: Master Sheet Admin is aware of a new registrant and manually adds to the…
Sorry if my question is unclear. Here's what I'm getting at: I have an onboarding training checklist I made for all new hires. Each new hire has their own individual dashboard. Basically, I want to add the general onboarding checklist (which is a sheet) to each employee's dashboard. However, I want to know if there is a…
I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the…
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.
I'm looking for a solution to use forms for collecting employees' vaccinations and other occupational health requirements for employment. Different from the current templates that help track pandemic items. We need to be able to send a form during employee onboarding to request that the candidate submits their vaccination…
