-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Solution Spotlight- Healthcare Capitol Construction Demo
Hello all! Our Commercial Solution Engineering Team is hosting a demo of a capitol construction solution on June 25th at 11am PST. Here is the published Smartsheet Dashboard if you are interested in registering! If you can't make it, but still register, we can send out the recording. We also have a special guest, Neil…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Email automation with attachments?
Hi all- Wondering whether any of you have worked with automations involving sending emails with attachments. I am working on improving our system for issuing travel reimbursements post-conference (we have to use a specific Excel form for now sadly), and we are currently using Smartsheet/Generate Document to generate…
-
Repeat cell until Value of 0 occurs again
Good morning, Looking for a formula to do the following: I would like to return "ASSY-00572" in "Column16" for all rows up until "0" occurs again in column "level" Then I would like a formula in column "ASSY TOTAL" that sums the "EXTENDED" column for all rows that list "ASSY-00572" in "Column16"
-
More options for Time entry locking in Resource Management
Currently there 3 Time Entry locking possibilities in Resource Management to choose from: 1. Do not lock time for a project 2. Lock all time entries for a project 3. Lock time entries for this project that are older than xx number of calendar days. Idea: enhance the Time Entry locking states by introducing additional…
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
I have paid upgrading plan from Pro to Business, but the account still in Pro Plan, how to solve it?
Hi everyone, I need help, I have paid upgrading plan from Pro to Business, and i also received the payment invoice on my email that said that i have paid for business plan (screenshot below). But, my account still in Pro Plan (screenshot below), then i still cant use grouping at the report, etc. is there a wrong way? Does…
