-
Can I get an email alert when someone comments on my assigned column, but not have it alert me
I like the idea of getting an email whenever someone comments on my assigned column, even if they don't @ me, but I don't need to get an email notification when I comment myself. Does anyone know how to build out this specific automation? Thanks, Will
-
what is the formula to collect Sprint no, based on the start date for a task from another sheet
I'm trying to use =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@row), {Project PI & Sprint-End Date}, >=[End Date]@row, 1) but its not working I want to add a formula in this sheet to provide Sprint # based on the start and end date for the task, refrencing to another…
-
On a published calendar (created using the Calendar App), the Filter a greyed out. Why?
When I look at my Calendar, I see the filters I created, but someone else without or with an SM license can see the license.
-
Can someone please correct my COUNTIF formula to establish an active project?
I need to have a cell counted between two date ranges. The first set of dates, denotes project start, the other is project end. So, if my project end has not exceeded today, it means it is still active =COUNTIFS([Const Start]6:[Const Start]39, "<=" TODAY(), [Const End]6:[Const End]39 ">=" TODAY()) Thanks in advance for the…
-
Can You Include An Image Column in Document Builder?
Hi Smartsheets Community, I have build a fillable PDF in order for me to use the Document Builder in one of my projects that I am working. In my sheet, I have an image column (see screen shot below). I have included that column as a field that I would like to be included in my Document Builder. When I run my Document…
-
How do I set up an inventory management system in Smartsheet?
Hello, I'm looking for help setting up an inventory management system in Smartsheet. We have a set number of chairs, tables, linens, projectors, etc. that various departments at my organization use each day. I'm looking to create a system where they can input their daily needs, and it will show how many of each item is…
-
formula not showing Dollar symbol
I have column (B) join collect Items @row. I have Column (C) join collecting multiple Column (B) items based on unique values. =JOIN([Cost Center]3:[Rec'd Approval From 2]3, "-") I would like to have the dollar symbol in Column (A) to be present in columns (B) & (C) =IF(ISBLANK([unique.invoice]@row), "",…
-
Index | Match: How to Return Specific Value in Blank Cells
Hello! I am using an Index & Match formula to populate the following fields based on the chosen Integrated Participant: Group, RHMID, Class of Trade, and GPO Start date. I want any blank cells (aka, data not assigned to an Integrated Participant) to display #NO MATCH. I am using IFERROR statements (below) that will return…
-
Is there a way to copy notes into the Comment for each row?
I imported data from a spreadsheet and it had a Notes column with running status updates for each row. I'd like to have them start using comments and thus want to bring in the data from the Notes column into a comment, so they can continue to see the history in a logical way. I don't see a way to automate the copying of…
-
Can you automatically populate the Owners list?
I have two columns: Task Team & Task Owner(s) Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column? Example: If Task Team = Technical, then Task Owner(s) = Bob If Task Team = Training, then Task Owner(s) = Kathy and John