-
Dashboard - Formula help for date fields
Hi I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all different dates) please can someone provide the formula that will allow me to make a count of…
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
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!
