-
Collect most recent date from another sheet based on certain criteria
Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a quick reference to see the most recent service per vehicle per category. Being multiple services will but under a category I…
-
Is it possible to Update Cells in Both Sheets when they are Linked?
What we are trying to do is use one sheet as a general project breakdown (Sheet 1). Within that project breakdown is a construction schedule. We want to make a second sheet that contains all the information in the Construction schedule section of sheet 1 and turn that into its own sheet (sheet 2). I know this is possible…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
Why dont non working days carry thru to other projects?
I ticked the box to apply to all of account but they dont show or take effect in other projects? What am I missing or did not do?
-
Copy row automation from a formula based column
I have 3 intake sheets for a multi tier blueprint, I am using data shuttle to bring in all of my clients, program and project to one master sheet and from that master sheet, I have 3 formula based check box columns to track if the client, program or project exists or doesn't exist. If it doesn't exist I want to copy the…
-
Getting Permission Error Message Copying Rows to another Sheet
Hi, Can anyone help out? I am getting an error message copying rows from a sheet on which I am the owner to another sheet where I have "editor-can share" permissions. Error message obtained is "You do not have sufficient permissions on this sheet to make this change". Lisa
-
Sheet formulas are not auto-updating until the sheet is opened
Is this still a known issue with the TODAY() function OR is there a way to get around it? https://community.smartsheet.com/discussion/59131/sheet-formulas-not-auto-updating?_gl=1*hx7amf*_ga*NDg5OTI2NTg5LjE3MDYwMzk4MDY.*_ga_ZYH7XNXMZK*MTcwNjgwOTkzNi41LjEuMTcwNjgxMDAwMy41OS4wLjA.
-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
