-
How to add if cell is not blank then...or if cell is blank then leave blank?
Thank you in advance. I have the formula working that I need which is this: =IF([PO Amount]@row > 100000, "Level 3", IF([PO Amount]@row > 50000, "Level 2", IF([PO Amount]@row <= 50000, "Level 1"))) But I need to add text that indicates if the cell is blank than leave blank or if it is not blank than the formula above. This…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Auto- fill information from another smartsheet
How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate are a unique name and contract number (in separate columns) and I want to have them pre-populate on a contract deliverables…
-
How to automatically generate a Date that's three weeks later than a given Date in another column?
I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type). The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually…
-
How to write a formula if then formula with multiple conditions
The formula I am looking for is if a PO Amount is greater than 50,000 then return a circle but if it is greater than 100,000 return a square and if it is less than 50,000 return a triangle. I have tried =IF([PO Amount]@row <50,000, "triangle", IF[PO Amount]@row >50,000, circle, IF[PO Amount]@row >100,000, "square") this…
-
How do I write a formula that returns a circle if a PO value in another column is greater than $100
=IF(["PO Amount"] > $10, "Circle", ["PO Amount"] <$10, "Square")
-
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)
