-
Average by section within a column
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…
-
Columns rearranging
Hello, I want my ~50 columns in my sheet in a certain order, however after rearranging several times, the columns move out of order. I do have a sheet connected to this sheet by a move automation, but I also rearranged those columns in the exact order as the first sheet. How do I keep the columns in the specific order?…
-
Elapsed Days in Predecessor Field
Hi! Could you add the ability to enter in elapsed days (non-working days) into the predecessor field? This would be similar to the e#d in duration. Thank you!! Kind regards, Helena
-
Incurred hours not showing for future dates within the same month
Hi everyone, We are using Smartsheet Resource Management for capacity planning, operational follow‑up, and monthly financial reporting, and we have a recurring challenge related to how Incurred Hours are handled in reports. We understand that incurred hours are date‑driven (past vs. future), and that this behavior is…
-
Copy Row Automation Not Working
Good day, I have the above simple automation to copy a row to another sheet when a specific checkbox is checked. I am having two issues: The automation does not run when the box is checked When I run the automation manually, all the rows in the first grid, are copied to the destination grid. How can I fix the automation…
-
RANKEQ with INDEX / COLLECT Across Multiple Sheets
Hello Smartsheet Community, I have a need to INDEX / COLLECT dates from multiple different sheets with individual users. The goal is to look at various schedules for a list of users and deconflict dates that overlap on all of the schedules that a user is found. I can't do this with a report, as the assigned user is a…
-
Smartsheet Shared as Admin but User Cannot Input Data
I have shared a Smartsheet content to a user within the organization and the access provided is "Admin", however the User is unable to input any data. The same access has been provided to a different User and the behavior is different, user can edit any lines. Is there any particular access that I need to check to ensure…
-
Conditional Logic in Forms
I’ve started building a form in Smartsheet using the Smartsheet Form Builder, and the responses are successfully populating my sheet. The challenge I’m running into is creating conditional logic within the form to narrow down selections. For example, if a user selects a state (such as Florida), I’d like the next question…
-
Backup all workspaces
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
-
Option to Not Include Sheet Link on Notifications
Frequently notifications are sent to users that do not have sheet access. It would be very useful to have the ability to select specific columns AND turn off the sheet link (that is prominently displayed). The 'MESSAGE ONLY' option works ok if you only have a small number of columns to include AND you aren't sending the…