-
Sorting in a sheet and in the team task board works different?
Hi all, I am working in a sheet with a projectplan and I am working in a Team Task Board, as far as I understand this is also 'just a sheet'. When I sort on owner, due date etc in the projectplan, the parent/children relationship is ignored and that messes up the whole project plan (there is no solution for this right? I…
-
Formulas with checkbox columns
I am trying to count the number of instances within a parent group that a checkbox is checked. I'd liek to count the number of checkboxes per parent group on my sheet, I have many parent groups. Below is one, it has 7 children. Here is my setup... I should get 5. But I am 22, the total for the whole sheet, not just for the…
-
Published Gantt does not display on mobile device dashboard
Hi, I created a Dashboard that pulls in a published (Read Only - Full) Gantt chart. When I view the dashboard on my iPad it does not display the Gantt, however. Instead of the Gantt it displays a link https://app.smartsheet.com/b/publish/.... (see picture). The dashboard displays fine on my laptop. Is there a mobile app…
-
How do I show child AND PARENT rows in report?
I would like some help on how to show parent and child rows in a smartsheet report. See this loom recording for more context: https://www.loom.com/share/b55c7ed651994c2d8cfbbf1ed0d04665
-
Handling Duplicates
Bula (Hello) what is the best way to handle duplicates in a smartsheet grid? conditional formatting seems to come to mind, however, what if we have a scheduled import of data, e.g. via DataUploader or MS Power Automate? we haven't found any methods or features there to handle Updates or Duplicates. looking for any other…
-
Determining Workflow trigger criteria
Hi, I asked a question but from the reply I received I think I asked it the wrong way so I am trying again. I am new at automating in SmartSheet so forgive the simple question: I created a Workflow which is a reminder email that needs to go out to several people 3 days prior to a Finish date if not 100% completed. The…
-
Question about users
So in Smartsheet, I can give people permissions to a sheet on the sheet level and it will prompt that person to create a smartsheet login, however they do not show up when I look a the users in user management. If I then re-add them through user management they are confused because they will receive 2 separate user…
-
#PERMISSION ERROR
Hi, A colleague of mine owns a workspace (for a project) with different folders and files. In one of the files (grid), she is using the following formula =Amount@row * (INDEX(COLLECT({FY22 - Currency Conversion Rate Range 1}, {Currency}, Currency@row), 1)) Except that the formula is returning #PERMISSION ERROR. The error…
-
Workflow assignment question
Hi, I am new at automating in SmartSheet so forgive the simple question: I created a Workflow which is a reminder email that needs to go out to several people 3 days prior to a Finish date if not 100% completed. The conditions part of this workflow is straightforward, but I am unsure how to connect and activate it. From…
-
Pre-populate form using URL query
I'm trying to pre-populate dates from a schedule to an inspector request form, but only the first field (Start Date) is populating, the End Date is not. Here is my code with URL xxxx out. ="https://app.smartsheet.com/b/form/d485bfc4cbfc471882eb77ed6042ace9?Start%20Date=" + [Start Date]@row + "&End%20Date=" + [End…
