-
Pull the automated count of elements
Hi all, I noticed that when I'm creating a report using the What? button I select the column that I need to show, it automatically shows me the elements found for that column, and what a surprise that those elements contain the included count number. My question: Is there a way to get that counting number, instead of…
-
Coverpage for Tempaltes
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package. Right now, we use the export to PDF, and add a few notes in the provided comments…
-
Change Order of Sheets in Report
I have two sheets that show data from two different fiscal years: * [FY 2019] Course Development Tracker * [FY 2020] Course Development Tracker I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker. I thought…
-
Report Not Updating
Hi everyone, I have a report that is not updating to show a newly added row. The origin sheet has been saved and refreshed. There is no criteria listed on the report that would affect the data to be shown. I'm new to Smartsheet user forms, so I'm not sure if my report is somehow affected by the form or reference sheet.…
-
Limitation of 5000 rows in Smart-sheet
Hello, As I woud like to know the reason, why exactly smart-sheet has 5000 rows limitation? Actually, my database is the master file which is joned to the indenting pasrt with all user. Every row has different material code which is aligned to the indenting sheet. As my database is now over 5000 Rows what exactly I should…
-
Error while uploading attachments
When i try to upload files to the smart sheet , any mail attachments or documents. I'm getting an error message and it doesn't allow me to upload the attachment.I have attached the screenshot of the error message. please help me with the same.
-
IF Function help
I am attempting to use a nested IF statement that assigns a number based on a dropdown selection. Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection in the next column. =IF([Care Training Impact]1 = High, "60", IF([Care Training Impact]1 = Medium, "35", "2")) I receive an…
-
COUNTIFS function
I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column, how many of them come after the date 07/01/2019 in the other column. Does anyone know the syntax for that? The column names. The checkbox column is "Approved", the…
-
Slow operation
Our company has about 100 users on smartsheet. It was recently report to me that many people are having issues with slow operation while using smartsheet, so slow that is effecting their productivity.
-
Group by function in reports
Does anyone know when Group-by in reports will be supported? If I remember correctly, it should be in this year (2018). Thanks for your advice!
