-
How identify where actual lag time is different from standard lag time?
Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. My workplan includes: 1. Predecessor column (includes predecessor with +/- lag) 2. A separate text column "Standard Lag Time " Whenever the lag time needs to be changed the predecessor column is updated. The…
-
Sheet Summary COUNTIF
I'm having problems using the COUNTIF function in the new-ish sheet summary. Everytime I sort rows it changes the range. For example, in a summary text field I have =COUNTIF([Column A]1:[Column A]79, =0) After sorting by a column it becomes =COUNTIF([Column A]29:[Column A]43, =0). Or something similar. The sheet summary is…
-
Method/formula to rename sheets, reports and dashboards in a folder
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and…
-
Card View multiple perspectives
The Card View is awesome, creates verticle swimlanes for each value in a drop-down field. I'm wondering if there is a way to add a second perspective to the Card View from a second drop-down field. The secondary values would render as horizontal sections. For example, the verticle swimlanes might be departments, but the…
-
Formula Function - SMALL for dates with duplicates (ERROR)
Hi, I'm currently using a formula to INDEX my sheet and pick up the smallest date in a column, and then display the 4 smallest (or soonest) dates in that column to pull into my dashboard. The formula is as follows: =INDEX([Project Name]:[Status], MATCH(SMALL([Next Milestone Date]:[Next Milestone Date], 2), [Next Milestone…
-
Consolidating Data from Multiple Sheets
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. I'd like a single sheet I can look at each month that will…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…