-
Change next row status when previous row status is complete
I have multisteps to complete an order, Since start of many steps is dependant on the completion of previous steps, Can I program that if a previous steps say row 1 and 3 are complete (status Green), next row status changes to Yellow. I did this by giving code to each row and then with IF statement (If Code of row 1 and 3…
-
FORMULAS
I have a smart sheet for job progress I have indicdual lines of % of jobs what formula do I use at the top to get the overall % of all jobs.
-
Sharing with large numbers of external users from multiple organizations
We are developing a worksheet that we may wish to share with users in two other organizations. We would want to be able to share with any user in the 'abc.com' domain as well as the 'xyz.com' domain. Is there a way to do this, without making it available to the entire world, and without having to add/manage all of the…
-
Formula for pulling Start and Finish from cell
Is there a way to pull Start and Finish data from a cell that has both? I'm importing a spreadsheet schedule with cells that have both dates expressing a date range, eg. "2/1 - 2/7"
-
Backup - Link attachements to row ID/number
Hi, When you make a backup of a sheet with many attachments such as pictures and pdfs these will all be downloaded to one big ZIP folder. Say you have 500 rows with attachments, there is no way to link the attachment to the right row. Is it possible to automatically rename attachments as you upload them? With row number or…
-
Sum up data NOT using parent rows
Hi team, got a tricky one me thinks..... (screen show below for assistance). I need to add the quantity required on any given day. I was using parent rows - which worked fine, until the dates went out of sequence - which will happen and must happen given our workflows. Basically I want to know at any point in time the…
-
Very poor performance/speed of Smartsheet
My Smartsheet has been running SOOO slowly for about 5 days. It's a nightmare. Can barely work. I am located in New Zealand. Any ideas or tips anyone? Have already had our IT team check my laptop. Only Smarthseet that is a problem. Any advice gratefully received! I have deadlines approaching and Smartsheet is practically…
-
SUMIFS...Its working but when i add.......
Hi Team, Formula below works.... =SUMIFS([Value of Jobs]2:[Value of Jobs]5, Result2:Result5, 1, [Sold Date]2:[Sold Date]5, MONTH(@cell) = MONTH(TODAY()), [Sold Date]2:[Sold Date]5, YEAR(@cell) = YEAR(TODAY())) but when i add (In Bold) (Sales Stage is a drop list row with "WON" in it) It dosent like it ??? =SUMIFS([Value of…
-
Enhancement Request: Improved Community Search
If this is already possible, I can't find it. I want to be able to filter and search by Topic. If this is not implemented, why should I bother clicking the selections? For example, if I wanted to search ONLY the items that were tagged with "Comments" and not get a hit on just a phrase like "she made comments" Craig
-
Is there a way to see all sheets that have been shared?
As one of our Company user with a license, I do some overviews of Smartsheet with new Users. Is there a way to view all of the sheets a non-licensed user has been shared? This would allow me to go over those sheets specifically. It would also be helpful in the cases where a user changes roles and some of the access may…
