-
Send Automated Alert to Group
Is it possible to send an automated alert to a group? It looks like the only options are to specific people, contacts in a cell, and everybody shared to the sheet. I have two groups shared to the sheet, one has Editor capabilities while the other is just a Viewer. Is it possible to send to just one of these two groups? If…
-
Cross Sheet Formula, COUNTIFS + AND?
Hi!!! Tried this and it is #UNPARSEABLE: =COUNTIFS({cost savings check}, 1), AND({OPENED}, >=DATE(2023, 1, 1), {OPENED}, <=DATE(2023, 12, 31)) I've been noodling with it but can't seem to get it to work, help would be greatly appreciated!
-
How to get all drop down values to pop up in one cell?
If I wanted Interns and IT to pop up in the highlighted area automatically, what formula/feature could I use? If there is a way to do that, is there any way I could have the attendee name pop up only if they checked off 100% Confirmed in the column on the right?
-
Can you add a hyperlink to a cell that's linked in from another sheet?
I'm working on a tracker & we're basically trying to find ways to combine columns. Currently we have a Sheet Link column and a Revenue column. We manually add the hyperlink to the Sheet Link column while the Revenue column links in from another sheet via formula (based on a unique ID in another column). Our goal is to…
-
Formula Help - Identify a quarter
So my sheet i am pulling data from has a column labeled "F*Sold Month #" (range is labeled CTC Residential Sales Rep - Month) . I am trying to do a SUMIFS formula that sums if that column is 1-3 (1 or 2 or 3). Essentially trying to break down a sum based on the month so i can get to what the quarters sales were. Most of my…
-
Using RYG to determine health status of progress made
This is a question I am piggy backing on.. Automating a Roll up for RYG Symbols for Health — Smartsheet Community I am also trying to use a similar formula but based on % Scheduled Elapsed, % Progress delayed and % completed. I'm using a template created but trying to make a new workspace that does pull from a different…
-
Pulling a list of users who are taking a course
I need assistance with creating an automated report for each course in my spreadsheet. The spreadsheet contains information about courses and learners. Instead of manually creating reports for over 100 courses, I want to establish a link from each course entry that leads to a report or filtered spreadsheet listing the…
-
SUMIFS not working with additional field added
Hello, I'm trying to do a SUMIFS Formula for a month. =SUMIFS({Period Month}, "January", {cuscode}, Category@row, {extprice}) I'm getting incorrect argument. Previously I did this formula for the total and it worked. =SUMIF({cuscode}, Category@row, {extprice}) Not sure why the modification isn't working? Amy
-
Formula help
I am needing to pull from the main sheet: If contractor is X, and it is X date how many "daily weld count" I need to put together a graph that shows contract X has # welds per day. I have managed to count how many entries there are for a given date but not the # in the "daily weld count" column. Here is the formula I used…
-
Asked to Calculate Average Monthly Submissions
Hello! I had a simple request - to calculate the average monthly submissions. While it's easy for me to actually calculate - I'm having trouble translating the request into a formula to track in the Sheet Summary. Each row is a request - so I have a 'count' of 111 requests. I have a "Date Submitted" to determine the number…