-
Report not picking up all checked Star symbols
I am running a report and using a Star symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when I go back to filter by…
-
Web Form Submissions Misplaced
I've created a new basic sheet with an associated web form. New web forms entries are being placed down on row 52 and not at the top of the sheet. How can I remedy this?
-
Report Sorting by Sheets Names Starting with Numbers Out of Order
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1,…
-
SUMIFS Formula Help
I want to calculate the Total Infill when the elevation is North, the floor is 2, and the L1 Infill Type - L10 Infill Type is GL-3. =SUMIFS([Total Infill]:[Total Infill], Elevation:Elevation, "North", Floor:Floor, "2", [L1 Infill Type]:[L10 Infill Type], "GL-3") This formula works perfectly if I only want to know the Total…
-
when/how changes are saved for multiple users
Hello, I am having issues with rows randomly being pushed to the bottom of my sheet. It appears that it is when there are multiple users saving simultaneously. When/how does Smartsheet save multiple changes? If I am typing and I receive a refresh prompt, do I save my changes or do I refresh first? This has been an issue…
-
IF Match formula failing. Can you use Children as the test to search?
=IF(FIND("Fail", (CHILDREN([Subtask Status]231))) > 0, "Failed Subtask", IF(Column231 = 1, "Pass", IF(Column231 = 0, "Not Started", IF(Column231 > 0, "Review In Progress", IF(Column231 < 0, "Review in Progress"))))) The above formula is returning #Invalid Data Type I also tried to break the formula down into two parts to…
-
Linking a drop down cell to the workflow
I have a drop down status cell on my customer sheet. I would like the info in this cell to be linked to the Workflow sheet in the status cell for each customer. I have tried to go to the Workflow status cell for a customer and link in from the customer sheet, this works and when the customer sheet status cell is changed…
-
Need help with a formula
here are the formulas and a look at the Spreadhseet. The Column labeled Column has the following formula =SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10))))) The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not Started", IF(Column10 <>…
-
Uploading large excel sheet
Yes, I read the blog posts from 2016/2017. I tried loading a sheet with 32 columns and received an error message indicating I had over 200 columns. In my opinion, the error message is misleading. Submitted this to SmartSheet support. Just wondering if anyone else is having an issue of this nature.
-
Schedule automatic reports for updates
I have project teams of 10-20 people and each are assigned tasks. On a weekly basis, I want to auto-gen a user-specific report of their task items and send a request for updates on all items. For example, every Tues at 11 am, I'd like to have a report generate that contains all assigned items where the % Done is less than…
