I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average. =AVG(COLLECT({Credit Granting Article Tracker Compliance…
I've created several "IF" formulas on a sheet. An example of one is as follows: =IF([Kickplate Installation]1, "$42.86", ""). When the checkbox is checked, it does return my value of $42.86. However, …
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Col…
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column with d…
I have a connector that pulls in all tickets closed after 1/1/2020, and the points associated with each. I want to sum up the points for all tickets closed each week. My formula is: =SUMIF(Week:Week, …
I have formulas in place to display based on differences between two rows. I am migrating from SmartSheet Commercial to SmartsheetGov and I attempted to copy the formula displaying a green UP arrow us…
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with ever…
Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin locati…
Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country se…
I've got this formula that returns the Name of the Parent =PARENT([Name of Request]@row) But, I'd like to add a link to the parent rather than simply return the Name of the parent My use case is Tasks…
