-
Multiple workflows in one sheet
Hey all, I currently have a source sheet with information regarding students in our organization's program. The first image is a screenshot of the source sheet with each student as a row. The workflows I have created are meant to add each student to a sheet that corresponds with the grade and CC lead as each lead has a…
-
Match all columns to complete
I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be "Go" If any column has "Incomplete" the column (Go/no Go) should be "No Go" I appreciate your help very much! Rob
-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
-
Countifs with multiple criteria along with a date range.
Hi, I am trying to pull specific data from my sheet along with a date range and the formula works fine up until I put in the date. This is what I am currently using: =COUNTIFS([NOW Case Details]:[NOW Case Details], "Meeting SAP Ariba Standard", Portfolio:Portfolio, "Business Network", Pod:Pod, "Seller Apps", AND([Today's…
-
How to Auto-Update Progess Bar
I need assistance with the appropriate formula to automate progress bar changes. I have attemped the formula I have seen in other posts, but I am getting error "unparseable"
-
IF formula to modify Month/Year of date column
Hi - I'm capturing a timestamp for when data is submitted into my form [Date Submitted]. I'm attempting to create a formula that converts that timestamp into a mm/yyyy format while subtracting 1-month from the timestamp. As an example, with a timestamp = 07/29/2022 my output should be 06/2022. If timestamp = 11/12/2022 my…
-
RemainingBalance to show on Source Sheet
Hello All! What is the best way to maintain a remaining balance? In my scenario, I want to show the remainng balance after each new invoice record. INVOICE SHEET I tried the following in the Remaining Balance field: =[PO# Award Amntt]@row - SUMIFS([Inv. Amnt]:[Inv. Amnt], Vendor:Vendor, =Vendor@row, [FYar]:[FY], =[FY]@row,…
-
Formula to return data based on text in another field (same row) but different sheet
Hi, Is it possible to write a formula to recognize specific data from a text field and return data from another field in that same row but in a different sheet? For example, I am putting together a dashboard to display the health, trend and status of the 6 top summary tasks in my schedule. I'd like a formula that would…
-
How to Auto Delete Duplicate Entries based on a User ID and Date?
Hello there, I am new to Smartsheet and trying to figure out how to build a formula to delete duplicate entries based on the "E number" and the "Content for the Week of". This sheet will be tracking form submissions and I want to delete any duplicate submissions by an individual for a given week. The screenshot attached…
-
SUMIFS to find total hours for this year.
Greetings, I'm attempting to get a sum of all hours requested for the current year for a specific employee number (JDE). I feel I'm close but getting hung up on the YEAR part. =SUMIFS([Hours Requested]:[Hours Requested], [Date of Submission]:[Date of Submission], YEAR([Date of Submission]@row) = YEAR(TODAY()), [JDE]:[JDE],…