I'm setting up a Project Portfolio grid which will be used to enter/update/monitor the current projects for our division. I would like to create a report (and a related dashboard) that will automatica…
I have a master sheet (linked to many other, scope-specific QC sheets) that calculates % completion per task. Each row is for a different task, and each task has their own amount of steps. This inform…
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how ma…
We're going into UAT soon. I've chosen Smartsheets to put all the test cases the testers need to run. Some things I'm wondering about - hopefully all of you ppl smarter then me can help: 1. I imagine …
Hi all, I have a smartsheet that my operations team manages. It tracks all orders that we receive through our defined shipping process. Each order is a new row and there are multiple columns. One of t…
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects …
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was ch…
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some…
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just w…
Hi, Im Senando Benig Jr, Just Sen for short, Im in manila Philippines, My company start smartsheet from scratch and im the one assigned to develop an application. I explore smartsheet for more than 1 …
