-
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…
-
How can I view 2 sheets at the same time? Goal is to make sure the rows are the same.
I am using the PMO template provided by Smartsheets. Under Project Level, I have a Template folder that I use to create new project folders (save as new). When I make a change to the project plan in the template folder, I would like to view the project plan in the other project folders. Right now, I would just like to be…
-
IfError returns "incorrect argument"
Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked. If I use: =IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0) I get "#No Match" when a value…
-
Finger gesture scrolling.
We issued Surface Pro 7+’s and Surface Pro 9’s to managers to use in the field now that Smartsheet has become the main system for work orders and assignments. For some reason, when using the browser or app on these devices, we are unable to scroll by touching the screen and swiping up and down or left or right. We can…
-
Copy/Paste is failing somewhat randomly
Hi, In recent times, my copy/pastes sometimes don't work. Most frustrating. One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste. It seems to be triggered by attempting to copy the value in row 1 down to every row in the sheet. Once triggered, even the…