Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
Managing Allocation % for Many Projects
I have a task that takes me 2 hours to complete, but I have 4 business days to complete that item. So, I have a start date of 02/04/17 and a due date of 02/08/17, so the duration column automatically shows up as 4 days. If the % Allocation column defaults to 100%, in the Resource Views tool, it looks like for 4 days, I’m…
keeping answers on different students together for different teachers
I am sending out a web form ~ having different teachers fill it out for different students. Can I keep all the answers together for the 50 different teacher specifically?
Spellcheck
Hello - I know you can use spell check from chrome, google etc., but it is not user-friendly when working with a large sheet. Please add my vote for a native spell check option.
How do I count new rows from web forms?
Hello, I'm trying to count new rows that come in on a web form below a specific row using a formula. How do I start my formula range on a specific row, then count all new rows that are below it as they come in from the webform? We use a webform to receive quotes from subcontractors. As they come in, they are moved up to be…
Collapsing rows on report
Good day, Is it possible to collapse rows on a report? Y
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.
Possible to do a bulk delete of sheets?
Ownership for some sheets that are shared with our VP of the PMO was transferred and when he got the notice he decided we need to clean up (delete) our Smartsheet ancient history. The number of impacted sheets (older than 3 months) is laughably small and I can easily delete them manually but I can't see them since I don't…
Wrapping cell text in reports
Hello all, I'm trying to build a Sight with several reports and noticed that I do not appear to have the ability to wrap the text in a report, is this true? It is making the layout of the sight much more difficult since a few of the task names and comments/updates make the report very wide. Plus it is hard to know how long…
index and Match
Hi Community Im having an issue with index and match 4 i have imported from Excel the sheet is set as follows Item Name Vendor name 1 vendor rate 2 etc, Example Item #102 Rate on vendor 1 20.00 rate on vendor 2 25.00 then i have a coulmn calculating the best price =min on vendor 1-vendor 2 and by best name i want it to…