-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Counting Checked Boxes in one column
Hello, I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas: =COUNTIFS([Missed Information:Missed Information], 1) =COUNTIFS([Missed Information : Missed Information], 1)…
-
Merged: AI tool to Document Workflows
This discussion has been merged.
-
What are Your DataMesh Use Cases - Dog Photo Attached as a Bribe for Your Response
Hello Everyone, I'm looking into what people are using DataMesh for within their companies and their own workflows. We just started a big push at my company for SmartSheet and are currently using just the core product. Being broken up by region/market/geography we end up with a lot of fractured data sitting in a bunch of…
-
STATUS UPDATE - Based on Date
Hello, I want the process wherein once we click on the task status for example: In Progress then start and end date are added, time time line status will read it immediately if it is "ON TIME" or "DELAYED" based on the end date. If we click on the completed - and the end date is not yet on the past, then it will ON TIME -…
-
Merge multiple columns into a single column on another sheet?
Hi, I have 3 columns on the same sheet (C1, C2 and C3) and I want to Merge them into a single column "A1" on another sheet. Is this possible in Smartsheet and how can I proceed? Thank you for your help. Best,
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering])) =COUNTIF([Resident or World Campus Offering], ="Resident Instruction") What am I doing…
-
Merged: When Copying or Moving Rows, Let us Choose Which Columns to Move Don't Just Default to All …
This discussion has been merged.