-
Sheet Divider & Section Freeze
Hello there, I'm currently working on building a very simple timesheet to capture individual time allocation. I have a few columns (Reference Section - Reference Section.jpg) with the following information: * Month * Number of Days (within corresponding month, excluding weekend and statutory holidays) * Number of Reported…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
recruiting conversion metrics
I'm looking to connect with anyone using smartsheet for tracking recruiting conversion metrics! My team currently uses sheets for tracking all candidate submittals and feedback between recruiters/HMs. Has anyone created a report or sheet to track the funnel conversion metrics from submission to hire?
-
SUMIF
Hi, I'd like a formula to calculate the below SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days. This is what i have so far but cant seem to get it to work.…
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
-
Automatic Archiving
I'm creating a weekly schedule in a sheet and I would like to automatically archive that sheet after the week is finished, and save it as the name of that week. Does anyone know how this would be done? Thank you!
-
Use Countif to count the number of tasks assigned to a worker?
Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble. I want to count the number of rows assigned to each contact, and I used the formula below: =COUNTIF(Assigned Work:Assigned Worker, "contactname") The formula returns the error #UNPARSEBALE How can I fix this?
-
Recurrent Reminder for anniversaries and Birthdays - old dates
Hi there, I set up a spreadsheet with all our employees' details. Now I need to set up recurrent reminders for Date of Births and Anniversaries, but obviously, being old dates they are not considered. Is there any way where this can be done? Thanks
-
Adding a grid to a Form
Hello, I'm wondering if there's a way to add a grid to a Form to collect data when multiple names, emails and job titles are submitted. Currently we ask people to submit a PDF form to us that has an embedded table where they list the staff who have taken a training. The table headings are: Name, Email, Job Title. Sometimes…