-
Pulling data from multiple shifts?
I am attempting to build a dashboard for tracking production performance. I have a form that is completed by each shift. I believe I need to pull that info up into a calculation sheet and from their I can populate the dashboard. I am getting hung up on have multiple shifts on the same date. I want to be able to see…
-
Concatenates in Smartsheet from Excel?
I'm in the process of moving my teams over to Smartsheet and having some difficulty migrating over information from excel that has excel formulas. Is it possible to combine multiple cells and add in a symbol, such as |, between two sets of data? The excel formula being used is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7),)…
-
SUMIFS with AND COONTAINS
Hi. I'm trying to do SUMIFS with AND CONTAINS. The logic is SUM entry from column A(referenced from another page), if Column B(referenced from another page) contains "Bryan" (must bring any hits that have Bryan in it, what comes after Bryan doesn't matter) AND Column C(referenced from another page) contains "Operations"…
-
How to Create an Automation Workflow to Recognize Addresses
Hello, I'm trying to figure out how to create a workflow where I can import randomized addresses into one column and receive an alert if one of those addresses matches the randomized addresses in a different column. I haven't had luck trying to work it out. Should I take a different approach, like the "COUNTIF" function?…
-
Getting user email address in smartsheet export
Hi- I am still getting my sea legs with smartsheet. I have the need to be able to export the email addresses that each user has that has been entered into specific columns in the smartsheet, however, when I export the smart sheet I am only able to see the users name. Is there a way to export the email addresses (could be…
-
How do I create an auto numbering system based on a value in another column?
I have a form connected to my smartsheet. I want a column (this example "Count") to auto number based on what another cell in a specific column has. For example, one column has either 'apple' or 'orange' displayed. I want another column to keep a count each time a row is added from the form, with either apple or orange.…
-
CONTAINS Multiple Columns
I have a sheet that tracks project works by [acronym] or [client name] in Primary Column, with additional columns that track what time assigned people spend working on each project. I want to SUM all project time for each client in the Sheet Summary with a formula that picks up those specific requirements, for example:…
-
Formula or conditional formatting for highlighting unique task names
Hello Smartsheet Community, I wanted to "copy" condition made in excel into my Smartsheet, and can't get it done right. I would need to highlight unique title for the task, which doesn't exist in a different raw. I tried some different condition option but it only highlight either blank rows or every one. No idea if this…
-
Increasing and Decreasing Totals
My smartsheet calculates points based on employee call-ins. When the points total changes/goes above 8, we send an email stating that the employee reached between 8 and 9.5 in half point increments. The question has come up where an employee is at 8.5 and then points get updated down to 8, another email is sent for review.…
-
Count the number of times a value shows up in a column
For whatever reason, I cannot find the right syntax to create a formula that works to count the values in a given column. I'm trying to use it for a sheet summary. I've been trying variations of this: =COUNT([Quote Validation Step]:[Quote Validation Step], [Denied]) I get #UNPARSEABLE