-
Dropdown menu for different criteria
Hi, I have two clients and I do not want them to see the whole drop down list, just want to show some based on the client. How should I do. Client : A, B Drop down menu for A : A1, A2, A3... Drop down menu for B : B1, B2, B3.. I want to use the same column for the drop down menu for creating the report. Any ideas for this?
-
bug?- level is changed automatically in Card View Mobile..
Hi, first set level to level1 in card view mobile.. after add subtask.. level depth has changed from level1 to level2 Below images is my workflow sequence.. 1.✔️after set level to level1(red number 1), press Add subtask(blue text A) 2.✔️after input subtask(blue text B), press SAVE 3.❌wrong result(result: A)/reason is…
-
Rows deleted by themselves
Was just showcasing a smartsheet to some work colleagues and while we were sharing our screen about 5 lines deleted. We had clicked sort on a column and when the screen refreshed, they were gone. I have checked the activity history and nothing is showing as lines being deleted. its really weird.
-
Notification issues - Some delayed, one user not getting emails
Hello, I have notification weirdness that I can't solve. I have two sheets with similar notifications. For one, when the automation is triggered, the notification shows up in a matter of seconds. For the other sheet ,the notification almost always takes one or multiple minutes and some don't seem to show up at all.…
-
Automated Reporting
In our organisation we prepare a number of different reports to different levels within the organisation. A lot of this information can be duplicated across different groups and levels. I am wondering whether we could create a sheet to capture these reporting updates from teams, through direct entry into the sheet, or…
-
How to find (max less one) from a list of entries
To assess whether a team is progressing, my user needs to show the most recent score AND the score just before that one. The difference between the two will show direction of development. Finding the score associated with max([date of score]@row) is reasonably straightforward. Any ideas about how to find the score for the…
-
Prep for the Core Product Certification
Hello, I am pursuing the Core Product Certification and was curious if it matters in what order to review the training materials: both articles and learning tracks for each domain? Is it necessary to review both the articles and learning tracks? One before the other? Any best practices would be much appreciated. Thanks,…
-
Get values from a column with blanks insert into another column without blanks
I have a some projects on a sheet that all follow the same template. The ProjName column has the project name (duh) and is the only value in that column for each project. ProjName - Task - Date - Comment project 1 - - - - First task - 1/2/2021 - comment1 second Task - 2/1/2021 - comment2 project 3 First task - 1/2/2021 -…
-
View pdf formatting in Document Builder
Hello, I created a fillable pdf, and placed a medium black border around each field in. Issue is I am not able to see the borders around the fields in the output from Document Builder. I can see the borders for the fields in the pdf builder when I preview the file in Adobe, but no where else. I also attempted adding a gray…
-
Stop counting blank cells
Hello, I want to display whether a project is active or not based on 1) it started in the past and 2) status is anything BUT complete. The issue is that Smartsheet is counting the blank cells and returning a value of yes, it is active. However, I want to have a blank cell return the status of No. I have my formula below,…
