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 tri…
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…
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 i…
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 dat…
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…
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 e…
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 g…
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…
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 w…
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 bu…
