-
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…
-
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"
-
Hi guys!
Hello, my name is Aziz. We use SS to monitor our work. I'm still learning Smartsheets and its automation and formulas and creating a dashboard and I'm always looking forward to sharpening my knowledge on this platform. It's a pleasure to be among you.
-
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…
-
Text Wrapping is not working.
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
-
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…
-
How to keep a running tally?
Hello! I am trying to figure out how to create a formula to keep track of the Annual Funding Remaining for employees. As you can see with the #CIRCULAR REFERENCE and #BLOCKED I am not having any luck. Can someone assist me? TIA!