-
Linking values in columns across sheets
Hello. I have a column in one sheet that I would like to copy over into another sheet. I would like this to automatically update when the source sheet is updated, but when I tried just implementing a formula that would set the values of the new column to the source column (with a reference to the other sheet) like in…
-
How do I prevent all the formulas in a column from changing to the same cross-reference?
Up until yesterday this was working - infuriating! Now when I change the cross-reference in one formula in a column, the rest of the formulas in that column change to the same cross-reference. How do I prevent this from happening?
-
Form - contact fields updating to override emails?
For years we have used a contact column to gather emails via forms which allow us to send emails but also lookup in other columns supervisors, etc by calling another directory sheet with the user email. Typically, if you try to type the email address in via the sheet, it will auto recognize the internal contact and place…
-
Fun with Formulas
Aug 5, 2:00 – 2:30 PM (EDT) Don't miss out on an interactive session dedicated to exploring Smartsheet formulas! Learn how to simplify and organize complex formulas, discover essential tips and tricks, tackle common troubleshooting issues, and exchange valuable use cases and insights with fellow community members. Bring…
-
Form Autofilling Field with Conditional Logic
Hello. I am currently making a form to track events associated with current locations. These locations will be referred to by their unique, 5 digit ID; however, this form will be used by many different people in and outside the organization, so I would also like to display the physical location so people can double check…
-
Submitted Date formula keeps changing because of Created Date time zones
I’m trying to create a reliable Submitted Date column based on the Smartsheet Created Date system column. The goal is for Submitted Date to capture the correct calendar date when the form was submitted and then remain unchanged. The issue is that the Created Date timestamp appears to be displayed or evaluated differently…
-
eMail not being correctly recognized in Contact field, creating a problem in FIND formula
I have build a email validation in my sheet where entered emails from a form are entered in a contact field. another field verify the address and validades using the following formula: =IF(FIND("@xxxxxxx.com", [Student eMail]@row) = 0, 0, 1) if the checkbox is triggered (=0), then the registration is valid, and the the…
-
Is there a way to upload an excel file to replace a current sheet?
I have a 6 column, 10,000+ row sheet that feeds into other sheets of data through vlookup formulas, that I update on a weekly basis with new information from an outside source. the columns stay the same but the row #'s vary. is there a way I can upload the new excel version of the data to automatically upload the existing…
-
How to get an average of various averages from a different sheet?
I'm trying to create a formula in sheet #1 that: Looks up all rows containing a certain email address in sheet #2 References a certain value in those rows (the values in question are themselves average formulas) Takes the average of all those specific values Displays that average back in sheet #1 I know there are formulas…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…