-
Lock a Sheet
Hi, Is there any functionality to lock a specific sheet. I dont think there is but this would really help for the situations explained below. There are two scenarios: Scenario 1 We have a master sheet, where all product information is pooled. there are 100 different columns and hundreds of rows. One team is responsible for…
-
COUNTIFS criteria is CELL+anything
Hi, I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tried to enter the search criteria into the formula like this =COUNTIFS({Other sheet Range 1},$Column$14 & * , ...)…
-
Creating Sub-Auto Numbers
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple…
-
Inventory Calendar
Hello! I'd like to create an inventory and link it to a calendar, allowing individuals to check out items on certain dates. This way anyone could open the calendar and see if the equipment they need is available on the date they'd like to reserve it. Is this possible or is my head in the clouds? Thanks in advance! Alex
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
FORMULA - Trying to set a Status based on Date and %Complete
I'm trying to set the RYG status of a task based on End Date and % Complete of the task. I've put a formula in place using =IF(AND(... but I keep getting the error "# INCOMPLETE ARGUMENT SET" Below is the formula, can anyone tell me what I'm doing wrong or missing, please.... =IF(AND([End Date]19 > TODAY(+10), [%…
-
Do Cross-Sheet References Impact Sheet Load Time?
As my Smartsheet app has gotten more complex I often try to find ways to simplify sheets and speed things up. The new cross-sheet reference capability has me wondering if it would be faster than the existing links when loading a sheet? I don't know exactly what goes on when you load a sheet but the save icon stays dark…
-
Generating an Auto-Numbering Row
If I turn on the option for auto-number row system, will the generator only apply numbers to 1 sheet? If I have multiple sheets, and have the auto-number system on for all my sheets, will each sheet generate unique numbers, or will there be duplicate numbers throughout the various sheets?
-
Admin can't edit sheet title
Good afternoon, While out of the office a sheet title had to be updated, and my fellow license holder, who is an admin for the sheet, was unable to do so under her profile. The rename option is greyed out. The only option for her to make changes in my absence is to login to my account. I trust her completely, but it does…
-
Color Changes and Filter Bar?
Perhaps I'm loco, but 02/13/18 during the morning hours, I did not notice anything unusual about my landing screen colors. I log on after I get home, and my open tabs are now Orange and blend in too well with the background, and I now notice a Filter bar. Was this an update? I don't like it. Can we please get another…
