-
Is it possible to have a column only be available to be selected based on the status of another?
I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?
-
Column Formula Alternative?
I have people entering information into a sample request sheet using form that allows the user to select multiple types of tests they would like to have run. The form populates "Sheet 1" and I'm using automations to create multiple lines on the destination "Sheet 2" using this solution: In the Source Sheet: Count of Rows:…
-
Pull data from other sheet.
Hi, new to managing projects on Smartsheet. Current struggle: Sheet A and Sheet B have "Vehicle Identification Number" columns with unique values for each row. Sheet A has an "Order ID" column, which lists the unique ID associated with the "Vehicle Identification Number" of the same row. I need to create an "Order ID"…
-
Can i link cells so when i fill out a form it links the new information to another sheet
Can i link cells so when i fill out a form it links the new information to another sheet (sales) the other sheet (sales) also has a form that gets filled out, would like one form to fill out its sheet(intake) but link the new information if sales is selected to the other sheet (sales)
-
Assistance pulling information from one sheet to another automatically
Hello, SmartSheet Community! I could use your help. I have created an example of my problem below. The actual sheets have many more columns. Sheet A needs information sorted by Person Name; Sheet B has information sorted by Pet Type. Sheet A - This is where I would like information to be filled in automatically based on…
-
Syncing links between Smartsheet and Salesforce
I use the Salesforce Connector to synchronize information between Smartsheet and Salesforce. One of the fields we want to show in Salesforce contains a link to a project dashboard in Smartsheet. The cell with the link normally contains the project name hyperlinked to the dashboard. However, the connector will only copy the…
-
Max and index match function
Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…
-
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
-
I am trying to calculate benefit eligibility dates.
I need to calculate the 1st of the month following 60 days of employment. Ex. If a hire date is 1/15/2024, then I would need the formula to return 4/1/2024 (60 days after 1/15/24 is 3/15/24, so April 1st would be the date they are eligible for benefits).
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
