-
Formula to calculate numbers of checked/unchecked occurrences in dashboard
I'm trying to create a dashboard widget that shows the our number of media articles by project, broken into those that mention our organisation vs those that only mention the project. Something along these lines, but instead of "Totals" / "Column 3" these would be RDA Mention / Project Mention I created the above using…
-
Populate Status Based on Children
I need a formula that will auto populate the status of a parent task based on its children's statuses. If all children have the status "Not Started", the parent should reflect "Not Started". If any children have the status "In Progress", the parent should reflect "In Progress". If all children have the status "Complete",…
-
Purchase Orders and Invoices Tracking Template
Hi - Am wondering if there has been a template designed to maintain hundreds of purchase orders along with the associated invoices that get billed every month. A view that would allow me to see which purchase order has been fully invoiced, or which vendors we need to contact to complete the process. I need to know how much…
-
Generate Docs - How to fix Font Size Issues - a guide
I'm was using Generate Form to create a PDF I needed. While I was getting the content I needed, the font size in the form was wonky and inconsistent. The first 3 fields were in LARGE FONT size while the rest were a standardized. I don't know why or how the this happened. I was able to find a solution after an hour + of…
-
Final step in Automation 'Alert someone' is not working?
The second/third step in my automation process is not working? It doesn't ask for when to alert so I would assume it is instant? The 'Admin Team Member' is not getting notified? Does it matter that in my test sample it is the same person as the approver?
-
Replacing all special characters in form query string parameters with a formula
I was attempting to use the formula below to replace special characters in form query strings parameters but my form is not populating with any information. I attended Engage 2024 and was very excited to apply to our form but something is preventing it from running correctly.…
-
Time format data change after uploading data to smartsheet from excel via Data Shuttle.
I am using data shuttle to upload data from local .xlsx file. Below is the data available in .xlsx file in "hh:mm" format. After uploading data to smartsheet by data shuttle, The value is changed and showing in below format. .xlsx file is generating from system automatically so i can not change or add any filled in .xlsx…
-
Graph source error - but not on all dashboards
Hi I have dashboards that to my knowledge have been working glitch free for a year until today - not impacting all dashboards and in some cases impacts some but not all graphs. The table next to it is the source data so clearly not deleted and nothing has been moved. Any quick fixes?
-
Summary Sheet Formula - Count 2 Selections from a drop-down in the same Column
Hi, I am trying to count both "YES READY" and "YES READY NO SHIELDS DUE TO CREDIT HOLDS" in a Summary Formula. This is a drop-down in a column and I am trying to include both in a summary formula.
-
Datamesh roles or multiple owners
Incorporating Datamesh roles or multiple owner capabilities into Smartsheet would significantly enhance its functionality and collaborative potential. Datamesh roles would allow for more granular control over data access and manipulation, ensuring that team members can interact with the data in ways that align with their…
