-
NetworkDays but using different days
Hello, I am trying to creating a PTO form but we have users that work weekends. In Excel, there is a formula, NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]), that allows to shift what is considered a non-countable workday. Is there a formula or a workaround for this formula? Note: This is not a Gantt sheet…
-
Need to formulate long date imported from form into a reportable date in Smartsheet
I have a form (not Smartsheet and unable to convert to Smartsheet form) that populates into Smartsheet. Dates come in long form (I.E. September 30, 2019), which means they are not reportable in Smartsheet. I need to get the long form date into a date format Smartsheet recognizes so I can run reports off of it. I have tried…
-
Creating a Training manual
Has anyone successfully utilized Smartsheets to create a training manual?
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
10,000ft to Smartsheet
Hi - I am currently trialling smartsheet as we as a company are trying to determine whether it can be used the same was as 10,000 feet. What i want is a list of names down the left - these are our project managers. Across the top the dates. I then want to shade in the days they are working on a project so say employee 1 -…
-
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…