-
Countif formula... using crosssheet formula
I've tried both... they don't work they say unparseable... what am i missing I want to I am looking to add up all P1's that have a region of America Break Fix and a status that is not finished or cancelled, then count all the P1's in the priority column. =COUNTIF({CS Current Months WO status - Status}="Open",{CS Current…
-
Group Columns
Hello, I do not believe this function is currently available but I would like to add it as a feature request. It would be very helpful if you could group a set of coulmns in a sheet and easily hide/show . There are many instances of columns that are not needed often, but would like to have available to see when needed.…
-
Embedding a From within Smartsheet
Hi - I've created a form for submission of items in my "email calendar". Our team goes into spreadsheet often, so I don't want them to have to exit to click on URL to submit email request. Is there an easy way to add it into Smarsheet so that they can easily submit a form within our Email workspace?
-
sumif formula
=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount) #unparsable The amount is coming from a vlookup from another smartsheet The past due date is a formula with in the same sheet
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
Custom email notifications
We use smartsheet to track enhancement tickets that is logged with us, I would like to setup a "custom" email that is triggered for every phase a ticket might go to, example move from phase 1 to 2 then a custom email gets trigered with our companys custom info and details around the ticket. ? We have an outside logging…
-
Calendar Tasks to outlook for assigned tasks only
I published the iCal link to my outlook calendar, the problem is that every task on the Smartsheet shows on my calendar. We have around 15 people to whom tasks have been assigned. It would be great if we could link just their tasks to their calendar. Having all the tasks clogs up the calendar and is pretty much useless. I…
-
View Ranges Used in a Sheet (or all sheets)
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page. Please see attached screenshots. Any help…
-
Avata CPD Enterprise connector with Smartsheet
Hi, Has anyone connected smartsheet to Avata ?
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
