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…
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =V…
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple tru…
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link t…
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I c…
Hi everyone! I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 diff…
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project shee…