-
Linking / Updating Sheets
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master Sheet), is where our team spends their day looking for requests to come through. In a second sheet (Change Requests Sheet),…
-
Take Action on Dashboard
Is there a way to take action on a report (checking on a check-box column) from a dashboard/portal?
-
Trying to return a value once, but not when cell value changes
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we set up automation so our price column changes to the lower cost, or to zero if…
-
Hiding Columns
I have a sheet that has a column for each day of the year. I go in each week to hide the previous weeks columns, but still displaying the rest. However, since 3/21 the columns are no longer remaining hidden to other viewers, editors, etc. Is there something I can change on the sheet parameters or elsewhere to ensure that…
-
Need assistance writing a formula for one column with two purposes
Hello! I am creating a budget sheet and I would like to have a formula that calculates BOTH: 1) SUM across several cells in a row when box is not checked AND 2) SUM down a column if box is checked. So far, I have been able to write a formula that calculates the SUM across several cells (and have added in a bit to return a…
-
Multisite Clinical Research
Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I have found some articles describing how you can use other products along with smartsheets to track just single site clinical…
-
Trying to identify cells in ALL CAPS vs Title Caps
I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
Smartsheet Forms - Displaying View Only Fields
We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those fields to be View Only on the Form (PM, Project Nm and Curr Go-Live Date). I haven't…
-
Sheet summaries OVERALL average
I was able to resolve a #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0). However, I am currently hitting a road block on getting an accurate average from my sheet summaries. Is there a way to get an average of all summaries not labeled OVERALL that will only…
-
Have there been updates to automation?
I've noticed recently that automation doesn't seem to be working... have there been any updates/changes recently? A basic workflow to update a cell value is not working: This workflow has been working without fail for nearly a year, and now all of a sudden, the cell value is not being updated. I cannot say how long this…