-
Populate a SmartSheet Template from a form entry
Hi all, I have a form where people request a guide be created. Once that submission is complete, I have to take several of those data points and create a workflow template. Is there any way to take the data from a row and map it to the template to create the client specific sheet automatically? I am thinking of something…
-
Pull most recent date from another sheet based on two criteria
I am trying to pull the most recent date that a recurring job. I have the facility where the work was conducted, the last day of the job and the job category on the other sheet. I need the category section of the formula to look for a word contained within the text.
-
% of check boxes
I am trying to make the row 20 box thats selected to display a % of the check boxes in rows 2-19 that are selected. I have tried a couple formulas none work. =COUNTIF([Complete]2:[Complete]19, 1) / COUNT([Complete]2:[Complete]19) =COUNTIF([Complete]2:[Complete]19, "true") / COUNT([Complete]2:[Complete]19)
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…
-
Adding a Table Widget to Smartsheet Dashboard similar to one in Power BI
So, here is the idea in Power BI we have a table widget which will show the required data we want. I know in Smartsheet we can make use of report for the same but why I am suggesting this is that instead of creating reports for every small piece of data to be shown on dashboard is kind of annoying so if we get a table…
-
Metrics Widget Formatting Issue
Hello, I have created several sheets and reports to be able to live track my progress in a teacher training program. I used a Metric widget to pull the remaining hours from my sheet into a dashboard which works beautifully in the desktop version, but when I look at the mobile version, the formatting is all messed up. I've…
-
Request an Update weekly automation only worked once and I can't figure out why
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
-
How do I fix contact names not appearing in the cells of a sheet?
When selecting a contact from the dropdown list in a 'Contact list' type column (used to assign leads for tasks), only the email address appears in the cell when a contact is selected, but in the address book the name + surname and email address is listed for each person. How can this be fixed? Thanks
-
Return multiple values based on two cells.
Using a VLookup I was able to get the budget manager column to return the multiple values based on the paying department. However, I also need it to return another person if the grant option is selected. The budget manager column on the first sheet is used for a filter on a dynamic view to allow only the contact and budget…
-
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…