-
Best way to pull data from different columns into one
I have a worksheet that is populated via a form. Worksheet is currently 300+ columns wide (I didn't build it, I inherited it). The form is used by facility management technicians. Each time they go to a client site to service facilities, HVAC units, refrigeration units, etc. they complete this form. Yes, they complete in…
-
Having Issues With "All Contacts" Via Send Function
Hello community, I have users that frequently use the Send function in both Calendar and Grid View to send to contacts, note, there is no Contact column in this sheet. These are simply recipients of the Send function. The issue they are having is that old email addresses they've used previously won't leave the "All…
-
Tier 3 Meetings
Hello, I am currently using One Note to present meeting minutes status to a high-level team regarding, work delay, Non conformance status, if work is on track, what support is needed and impact to other teams. I would like to transition to Smartsheet, but I am not sure of the best sheet to create. Can you help?
-
Feature request: How to merge cells in Smartsheet
merge data into cells like excel does in a user friendly way similar to this article.
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
Smartsheet Form Displaying Field in Scientific Notation
Hi all- I have a Smartsheet form that prepopulates from a calculated field Tableau. Previously, the primary field was populating just fine, appearing as a plain integer. This field is an integer in Tableau. Suddenly today after this form working just fine for a week, the field is displaying in the form in scientific…
-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
Automate Status Change Between 2 Sheets
I have two sheets, both with Status columns. Ideally, when the status in sheet B changes, I would like the status in sheet A to change. For example, if my tester (sheet B) changes the status to "Test Failed", I would like my Defect Critical status change to "To Be Reviewed" Can this be done through automation or do I need…
-
How to visualize the same timestamp that I see in the grid(sheet) and in dynamics view?
I created a dynamics view but the problems it's that the timestamp that I visualize its a different. I already reviewed the timezone an its set similar in my computer also I review the time format and its the same. Any solution or suggestion?
-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…