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…
Hello! Context: I'm leading the charge on tenant migration for a datacenter over 7 weeks. There are 10 teams (each with their own inventory sheet) and hundreds of services among all the sheets. Goal: …
Good Morning! I've created a conflicts of interest survey and I'm looking for a formula to then reflect on my dashboard for reporting. Can someone please help me identify how i can use a formula to co…
I am trying to figure out if there is a way to create attachments from Sharepoint URLs in mass. I have thousands of files saved on Sharepoint that have a standardized URL path and naming convention th…