I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budge…
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person…
I am looking to create a sheet that tracks who has viewed the monthly update videos on our company site. Ideally I would create a form that modifies the row, but I've read this is not possible. My ide…
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date…
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able…
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). Thi…
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. …
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Ba…
Hi, I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No. For example, I have a column of statuses and another column confirming if…
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select th…