-
"No Filter" view
After viewing a filter a user selects "No Filter" to return to the full sheet. Whenever I return to the "No Filter" view, the view is not what it was before I selected a filter. For example, I have a specific section expanded and all others collapsed. I select a filter, then go back to "No Filter" and all of my sections…
-
Nesting MIN and IF functions
Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. To find the…
-
Formula Date Remaining Static
I have aprroximately 30 sheets related to a corporate merger. In every sheet I have a formula that populates today's date +1 whenever a status column value = Complete. The formula is: =IF(Status2 = "Complete", TODAY(1)) This then triggers a reminder to a supervisor to review the task and approve its completion. So, the…
-
one task through multiple calendars
I'll try to explain what I'd like to accomplish. My task name has sub-tasks for example "custom","boxcut", "assemble","finish" that populate calendars. On the calendars they show all of the "custom tasks" for all main jobs. How would I setup a calendar to show all the sub-tasks for just the selected task. Such as the…
-
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
-
Inconsistent Updates in Smartsheet
It appears that I am receiving inconsistent updates to Smartsheets. Changes are made and saved, but I don't see them, when I changed the permissions of the user making the change from edit - can share to admin the changes populated within the sheet.
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
One Time Links for Update Requests
Is there a way around the ONE TIME Link, WE NEED THE UPDATE REQUEST LINK to stay active and allow more than one entry. This will allow the user to add notes / comments as they try to achieve the update and obtain the information
-
Formula - adding two columns based on a condition
I think I'm close but this is driving me crazy. I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday. I would like to know the total participation for the weekend. The formula for just Saturday or just Sunday works =SUMIF([Event Code]:[Event Code], "CL021718A",…
-
Remove Cell Linkage
I had previously created a sheet that inputted data via cell linking. However, the use of that sheet is no longer needed so I deleted it. The problem is that the sheet that was 'pushing' the data still shows the outgoing cell link. How can I remove the cell linking?