-
If condition for Symbols in Smartsheet
Hi Smartsheet Community, By any chance, is there a possibility to create automation here wherein if a user ticks all 9 stars, the status will be tagged as "Completed", else it will remain as "In Progress". Thanks for any help you can provide. -Mart
-
Connecting Two Sheets by Cell Value
I have two sheets - one for contract info and one for billing info. I'd like to be able to click on a row (or field/cell) in one sheet and be taken to the respective customer's info in the other sheet. I don't need to do calculations or inbound or outbound links. I only need to click on Customer X contract info and be…
-
"If" formula - Auto populate a defined text if a cell is blank?
Hello - unsure if I'm even using the right formula here, but I want a cell to populate the word "Requestor" if the cell is blank, and keep whatever is populated... if not blank. Or is there a way for a column that is currently a single select dropdown to default to the option "Requestor" and then would be changed if needed…
-
Yet Another Question on Email Attachments
Hi. I'm looking to receive an email notification through a workflow when a row is added. When one of those rows include an attachment, I want to receive that attachment as part of the email. I've seen a few posts about it - and the solution always involves clicking advanced options and marking some checkboxes. For whatever…
-
Countifs #incorrect Argument set
Hi, please can someone help on this formula? Program Site Range - A different sheet with multi drop down column sites Program Phase Range - A different sheet with single drop down column =COUNTIFS({Program Site Range}, CONTAINS($Metric@row, @cell), {Program Phase Range}, Justify$1) If I remove the Phase criteria, it works…
-
Display negative numbers as Zero and Stop count when complete
I have a Smartsheet which I have a column that is counting the remaining days until the target due date. =[Target Finish]@row - TODAY() I would like for the remaining days to stop counting once task is marked as "Complete" in status column. I am also interested in preventing the number count from going negative and just…
-
Circular Reference Error Not Appearing Initially, then appears later
I've created a few summary sheets which use VLOOKUPs from my master data sheet, as well as other sheets. I've noticed that when I try to do a VLOOKUP, the formula will initially work, and pull the data as expected. However after some time, I'll re-open the same summary sheet, and see that the VLOOKUP Formula has an error…
-
Status light, nested IF statement
Hello everyone, I'm looking to find some help with my status light formula. My columns are as follows: • Date Due (date column) • Progress (drop down column with: "Not Started", "In Progress", "Complete" as options) • Status (drop down symbol column with "Red", "Yellow", Green", "Gray" circles -- to become a formula column…
-
SUM Cells with COUNTIF Formula returning zero value
I've built a summary table to count the number of "Issues" that meet certain criteria. I'm using a the COUNTIFS formula to do this. This summary sheet feeds a dashboard that I use pie chart on to visually show the breakdown of Issue categories. Piecharts show an error in Smartsheet when they have a zero value to display,…
-
Help with multi selections and counting specific items/text
Hi team - I have a column that is multi select for with following: Microsoft Exchange Server 2013 Microsoft Exchange Server 2016 Microsoft Exchange Server 2019 N/A Question - how do I do a summary formula to count for something specific like Microsoft Exchange Server 2013 when other selections are made as well? If I do a…