-
Alert notifications as a cc function
Hello, I have an issue I have been trying to find a work around. I need to find a way to track or verify the alerts that go out based on the many many different automations I have setup. The alerts are being sent to a contact (not shared or collaborators) that is in a specific cell based on when a specific date or criteria…
-
JOIN function for child row
Hi everyone, I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as their ancestorial row. This is what I have so far for the parent and child row formulas (currently seperate) Parent…
-
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),…
-
Column Properties keeps reverting to date
Even after I have set the column property to Text and saved the sheet, the next time I access the sheet, the properties have again reverted to Date. Any ideas on how to correct this?
-
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?
