-
How to drag formula and prevent cells linking together reference sheets?
When I enter a formula (e.g countif) that references another sheet, and then drag this formula to the next rows and try to change the sheet referenced, it changes all the cells as if the formula is linked between all the cells. How do I replicate a formula I want to be in multiple rows but then edit each row to reference a…
-
Duplication Issue
Hi, I have created to forms with logic, duplicated, and am trying to edit independently--but when I edit the one sheet it is changing the logic on the other sheet...what am I doing wrong? (I am teaching myself smartsheets, so this is my first sheet created :) )
-
transfer invoice totals from one sheet to another
In Smartsheet we keep a list of invoices for a building projects, so one invoice per row. What we would like is to have a formula that adds up all the invoices (sorted by company) on a new sheet. Hope my question is clear... Its frustrating that there is no helpdesk/phone support you can contact.
-
Locking a Sum Formula
Hello - I am wanting to lock a sum formula and am not sure exactly how. Do I need to add additional aspects to the formula beside the "$"? The issue is people are moving items around in their timesheets which adjusts the below formulas and I want to make sure if they do this, the formula will not change. Below are the two…
-
Holding A Column Position in VLOOKUP Formula
Issue = Within my VLOOKUP formula =VLOOKUP([Example]1, {Test}, 16) the column position is 16. If at some point a column is inserted to the left of column 16 in sheet {Test} then my VLOOKUP formula returns incorrect data! Question = Is it possible to get my VLOOKUP formula to hold to the column itself rather than its number…
-
Dual parameter formula to capture last entered date versus last date of column?
Currently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into individual columns. Using a MAX/COLLECT reference formula I am able to retrieve the last…
-
COUNTIFS and YEAR(TODAY()) not working
Hi, I'm trying to set up a formula, but the result comes up as #INVALID DATA TYPE. I'm at a loss of what's wrong with my formula. I'm using a very similar one in a different sheet and it's working. This is the formula that's not working: =COUNTIFS(City:City, City@row, [Event Year]:[Event Year], YEAR(TODAY())) And this one…
-
Automated Emails - From line taken from Form?
We have a form that is used to submit requests to a sheet. Upon the new row being added, an automated email is generated. Is there a way for the automated email to use the email address submitted on the Form as the "From".
-
Linking Summary Sheet Field Data Into an Existing Sheet to Report on Multiple Projects
Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding milestones, non-milestone status, and #of outstanding non-milestones. From there, I am…
-
Compare dates in the same row but different columns
Hi all, Im looking at counting the number of times two date columns differ within the same row For example Column 1 Column 2 11/2/20 11/2/20 11/4/20 14/11/20 11/3/20 11/3/20 25/5/20 12/6/20 In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both…