-
Can you sort rows or filter in the iOS app?
I am trying to sort a list from ascending to descending in the iOS app. Or filter out values less than a certain number. Seems like this would be very standard functionality for a spreadsheet. Am I missing something? Any help would be greatly appreciated.
-
How do I delete a Dynamic View that no longer works
Getting the message: "This view is currently broken. Please contact the view owner." Unfortunately, the owner of the sheet no longer works here. I need to clean up the dynamic views as they are causing confusion. I am an administrator for the company account.
-
maintenance sheet work machines
Hello, Does anyone know how to make these cards (type card attached screenshot), connected with SmartSheet that can be connected to another management control worksheet?
-
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…