I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the …
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new cou…
This might be simple, but I am a beginner. Team members will be pasting one of these 10 cities/counties into the Area column and selecting either “Experimental” or “Written” in the LOB column. I want …
I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet. =COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 …
Hi - I am having a problem with my SUMIF formula when it contains the 'Scheduled' column. My formula works if I remove the "Scheduled' column, but when I add that column, I get the message '#Invalid D…
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also…
=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1)) Hello i am trying to find non blank in a column based on the criteria that is after 1/1/…
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm tryi…
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pac…
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather…
