-
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…
-
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…
-
FIX Required: Last Modified Date + TODAY Function = updates all rows
Hello Smartsheet community I would like to see a fix. When you use the "TODAY" function anywhere in your sheet, ANY changes will update the "last modified date" for all rows. What I want: Only update the individual row that has changed. Why? So I know when (and who) made the last change. This was verified as a problem by…