-
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…
-
Filters and collaborators
I have staff that are set with the correct permissions to edit the sheets, but they cant see my existing filters. Is there a way to enable that view that I'm just not seeing or do they just need to build their own?
-
Sending Alerts based on Business Days
Hello, does anyone know if it is possible to send alerts based on business days instead of only days? We are a M-F operation and will not respond to customers over the weekend. thank you
-
Apply an updated template to a group of sheets
I have a group of about 50 sheets which I created using a customized template. I need to update the template (add a couple rows, add conditional formatting) and am wondering if there is a way I can apply the update on a mass scale to the sheets I've already created. I really don't want to have to update each one…
