-
Where has Create a new sheet gone??
Hi The option to create a new sheet just a plain sheet has gone from the Home screen. Now all you have is "Solutions" or Grid, Form, Dashboard etc when I do not want anything with anything pre filled just a plain old sheet I can create myself. Why has this disappeared and why is it so hard to find out how to do the…
-
Formula for counting how many times a cell has been updated
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would expect to see "2" in a cell titled "Number of times date updated". Delays can happen for various reasons and I would like to…
-
Create a report from multiple sheet but with row as Columns
hi Friends, I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3 In each of that folder we have many many files, one of them there is a…
-
Help to set up metrics on Project Raid Logs
Hi, how do i set up a metrics sheet to gather all information from our project raid logs. We have around 70+ Project raid logs for individual projects. I would like to create one sheet to display metrics such as - How many are red, Yellow and Green, Also which dept they sit in etc.. Im not sure if reports does this but…
-
Sheets > Timeline View > Fix scroll bar time-jumping
I opened a support ticket reporting this bug and the agent suggested I open the idea here. Currently there is an issue where if you drag the slider bar at the bottom while in Timeline View, it will "jump" drastically into the past. I've gone as far back as 2001. Note - there are no dates on my sheet before January of this…
-
Merged: Timeline View as Default View when Publishing Sheets
This discussion has been merged.
-
Parents and children integrity
Hi I have a single sheet that has parents and children. What I was hoping to do is use Dynamic View to allow various people to add rows. I was hoping that it would automatically add/ categorize the rows into the relevant parent group. However when testing this it adds it to the bottom of the sheet. Is there a formula that…
-
Column and Row Transpose
To whom it may concern, It would be very helpful to have a simple feature to View Columns as rows and vice versa within a sheet. A simple setting to allow the column headers to appear as rows and row information to appear on top. With the associated cell data still in the correct position. Please and thank you. Kindly, Dj
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
Automation Workflow Asssistance - Trigger based off Task's due date
Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B and Task C need to be completed before Task A can be completed. I am wanting to create an automation to notify the assignee…