-
#Circular Reference when automating Yes,Hold,No decisions
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="Win",Status1="Yes",IF([Lead Result]1,="Negotiating",Status1="Hold",Status1="No")) Posting a screenshot of my sheet for…
-
Formulas: Countif / And / Children Rows
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts.
-
Automated Row to bring up
Is there a way to automatically bring up rows that are in the bottom of the sheet? for ex: bunch of tasks that are live, done and on hold respectively. Is there a automated way to bring the live rows up, done rows at the bottom and on hold rows in the middle? I can do this with a report but was just wondering if I can…
-
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
-
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
-
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY
-
Weighted Percentage for Parent Rows
Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below; 1. (Project) Big Steel Project - 100% 2. (Parant)Steel Box - 50% 3. (Child) Bottom 70% 4. (Child) Sides 30% 5. (Parant)Steel Post - 30% 6. (Child)Short Posts 20% 7. (Child)Long Posts 80% 8.…
-
multiple date columns
i have created a sheet that has a notification date column and then a start date column and then an end date column. i only want the ghant chart to pick up the start and end date columns and not the notification date column. how do i do this???
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
-
Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…