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 buil…
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 dialo…
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 pullin…
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 ad…
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…
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 …
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 …
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNT…
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA A…
