-
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)
-
How Can I Set Up Hourly Archiving Without Breaking Datamesh?
Hi there, I need help setting up an hourly automation for our Department Calendar sheet. Here’s the situation: This sheet is connected to the Master Events sheet via Datamesh. When an entry is cancelled, Datamesh needs to trigger on the master sheet before the entry is archived from this sheet. If the entry is archived…
-
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…
-
Using a form to collect data on a sheet specific to a row
Context: We have sheet with a list of dates and meeting types as parent rows and then the agenda for each meeting as children rows underneath. In each row with an agenda topic, there is a cell that shows the presenter. We would like to collect details on who is presenting from non-editor users. I created a form that allows…
-
🚨 New Community Topic: Community Job Board
Hi Smartsheet Community, You shared your interest in sharing and learning about work opportunities in the Community — and we loved the idea! We are excited to introduce our newest topic: Community Job Board. The Community is full of talented Smartsheet experts, not to mention passionate professionals from all industries.…
-
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…
-
Is it possible to get a report on use of Pins?
Can I run a report on users activity related to Pins? Or could a CSM request this report from professional services?
-
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…
-
Is there a way to send out automate sending out dashboards weekly?
We use dashboards regularly for status reports, is there a way to send weekly to specific individual either as .pdf or interactive? I found this discussion and know it is on the roadmap, anyone know if it has been developed?…