-
Indexing from Multiple Sheets
Good afternoon Smartsheet Fam, I'm trying to create an index formula across 4 sheets to pull into a single sheet. The formula I have tried is: =IFERROR(INDEX({AHM.Client}, MATCH([CU Project ID]@row, {AHMPlan.CUProjectID}, 0)), INDEX({ahmne.client}, MATCH([CU Project ID]@row, {ahmne.cuprojid}, 0)), INDEX({ahmse.client},…
-
Image Size in Board View
Does anyone know how to resize images in board view to make them take up less of the card? I created some images to differentiate my to-do list by three categories. I like this to be easily visible to help with prioritization, but the image sizes are so large that it's difficult to view my list. here's what it looks like…
-
number of tab issue desktop app
i'm using smartsheet desktop app but i cannot open more than eight tab in the apps; whereas checking on website came to know that we can open nearly 100 tabs on desktop apps. while clicking on + (icon) usually new tab should be open but in my case after clicking on + last tab gets reload & goes to home page. sharing a…
-
Web Version Loads The Same Sheet
Hello, With the new update I'm experiencing an issue I didn't have before. I use Smartsheet web version because I typically work with 20-30 tabs open and it makes it easier to use than the app. Since this new update, every day when I open my laptop I am prompted to log in (as usual), but when the sheets load they all open…
-
Unlicensed Users cannot enter data in the sheet, when they could before the changes
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
-
Alerts for max rows
Background: Shift information is typed into a main sheet in multiple columns/rows by multiple people, then at the end of the shift, the manager confirms the date, shift number, and shift information before checking a box that changes a value on each row, and triggers a couple copy to workflows. This is segmented into two…
-
Maximum cell limit/rows in a sheet
Hi, I know the maximum number of cells in a sheet is 500,000 cells in any combination of columns/rows. My question is does anyone know what happens if the sheet has hit its limit and people still continue to submit data via forms? Does it just not capture the data anymore? Is there any advance notification/warning to the…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
UPPERCASE text on entire sheet without formulas
Having to have helper columns for every column in a sheet with formulas to change all text to UPPERCASE that is input through a form from other people makes my very large sheet ridiculously and needlessly larger - and then there is the problem of data shuttle which does not shuttle columns that contain formulas, so you…
-
SumIF formula help
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…