Have a smartsheet with about 6,000 rows of tasks with 38 users updating. Since Smartsheet becomes very slow with that number of rows. As tasks are completed we use the move row feature to archive. How…
I have a single sheet used to log test defects. From this sheet I've created a summary section at the top for Open Items and Items by Status. I need to create another summary "Item Status by Sprint ve…
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as …
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it…
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its pr…
I recently became a Smartsheet admin for my company, though someone else is still the official plan administrator (when it comes to billing, etc.). People have been asking me to delete sheets for them…
I have a web form which users use to create a new line item that requires approval once added. An automatic notification must go out to the person that needs to approve. Thereafter a notification must…
Hi All, I am new to Smartsheet. I need some assistance on exploring how it is possible to do what I need to do using Smartsheet. Idea: I want to implement a agile methodology like SCRUM and use smarts…
I tried to modify the OR formula and combine it with a function involving RYG symbols: =IF(OR(IF(TODAY() - [Order Due Date]2 > 0, "Red"), IF(ISBLANK([Order Date]2, "Red")), IF(TODAY() - [Order Due Dat…
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached…