-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
Vlookup
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
-
Can I set a cell equal to all data from a column of another sheet?
I want to pull a whole column of data from Sheet1 into a single cell on sheet2. The name of the column on sheet 1 is "Emails". I can't get a formula to work. cell formula something like ={Sheet1!Emails}? I am pretty new to Smartsheet formulas.
-
Increment previous row by 1 using column formula (when condition is met)
Hello Smartsheet Community, Looking for what should be a simple solution here: ultimately need to increment count by +1 once a new Project name is entered in a new row. If there are 8 Items within a Project, they will carry the same Project Count value, until a new Project is entered, after which Project Count increases…
-
What's the best way to have several photo upload sections in smartsheet?
I've been asked by our superintendent if Smartsheet is capable of having a form with the below information: Supplier Invoice Picking List Number Container Open Door Photo Container Number Photo Seal Number Photo What is the best way to capture this information in a sheet/form? Thanks in advance :-)
-
Count when 2 Conditions are met
I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Green". So I tried using COUNTIFS… =COUNTIFS([Health:Health],"Green",[Status:Status],”Open”) Gives #UNPARSEABLE 😕 Can anyone…
-
certain cells remain locked until specific data is entered in another cell
I would like the ability to lock not an entire column or row, but just a single cell, and then unlock it when data is added to another cell. The solution could be implemented as a workflow.
-
Team Member Contact shows as email address
Hi all, One of my team members was invited to our Workspace (before I came on board) with his contact name as just email address, while everyone else has "Name" then email address. In our ticketing sheet, we use an Assigned To column that is a Contact List and his name shows there but when I run a workflow to automatically…
-
Timelines - multiple work streams
We need to collect, and summarise timeline info in several streams a) Activities by group, relating to their workstreams (seasonal busyness) b) Org wide activities (i.e.long term and annual plan etc), c) External factors relating to staff availability (school holidays etc) This is to aid in selecting best timeline to…
-
How to capture the Name of the person who changes the column value?
Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status). Do I need a formula for this? I used created by option in the sheet. Not sure if…
