-
Matching multiple values from multiple columns in linked sheet to fill cell with content from third
I have Two sheets, one that acts as a "Rate card", it is broken down into Job title / Location / Day rate and the second is a budget sheet. For Example, Rate Card Column 1 / Column 2 / Column 3 Project Manager / UK / £10 Project Manager / US / £20 Developer / UK / £11 Developer / US / £22 In my Budget sheet I have a…
-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
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.