-
Need help with IF AND statement using symbols
I need help with using symbols with formulas. The column property is set to symbols. My current working formula is: =IF(TODAY() > [Remedy Deadline]@row, "Red", IF([Finding Status]@row = "Finding is Closed", "Green", "Yellow")) However, my first IF condition needs to satisfy two conditions: (1) (TODAY() > [Remedy…
-
Adding a "Select-Case" Style Function for Easier Multi-Condition Handling
Hi I’d like to request a new formula feature that allows users to evaluate multiple conditions more cleanly — similar to the Select-Case structure that I had found in a programming language. Currently, we rely on nested IF() functions to test multiple conditions. While this works, it becomes extremely difficult to manage…
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
-
Having an Issue where I am doing a duplication check and what to email the duplicator email back
Hi, I need help figuring out a method to emailing a set of duplicate emails once. I have an intake for that records emails. If there are duplicate emails in the list of emails, I would want to email them back to tell them that they just submitted a duplicate email. However, The way i have set it up now, sends the same…
-
Forms data entry options
Hi all! I'm wondering if it is possible to create a drop down in Forms that will connect to a specific column. Like, if someone selects Project A from the drop down menu and enters 4 as the number of hours worked on Project A, that 4 would populate a cell under the column for Project A. I have folks who work on multiple…
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…
-
Merged: Email Hyperlink in Sheets
This discussion has been merged.
-
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")
-
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…