Sheets
Discussion List
-
Linking Two Sheets to update dynamically When columns are added and removed.In Formulas and FunctionsI have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
-
Using decision symbols: Yes, No & HoldIn Formulas and FunctionsHi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following paramet…
-
What formulas help join people, teams, AND roles (person may have >1 team and >1 role)?In Formulas and FunctionsStephen Covey says begin with the end in mind. I want to create views of people by scrum team and role as well as by role and scrum team (end result mock-up pictures below). It would be easy if EACH PERSON was only on 1 TEAM and only had 1…
-
Track minutesIn Using SmartsheetHello, Can I please just confirm the only way to track hours & minutes in a sheet is by paying for either the 10,000 feet or Bridge add on? Thanks, CharlotteAnswered - Pending Review 1 view 2 comments 0 points Most recent by Charlotte Patey Using Smartsheet
-
Workflow - recognising email domain as part of "assigned to" columnIn Formulas and FunctionsHi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "[email protected]". However in the field it wou…Answered - Pending Review 11 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
-
Cell Linking to Sheet Summary FieldIn Using SmartsheetI like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
-
Formula with range that goes from a certain row to whatever the current bottom row isIn Formulas and FunctionsMy formula: =AVG(COLLECT(IIQ28:IIQ99, [SE Manager]28:[SE Manager]34, "John Lennon")) First, I cannot use the entire column. There is data in rows 1-27 that can not be applied to my average. I want the range to go all the way to t…
-
Continuously evolving Sum formulaIn Formulas and FunctionsIs it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul …Answered - Pending Review 12 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Daily Update Solution without the need to open the sheet, use Zapier, or similarIn Formulas and FunctionsHi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called h…
-
Formula issueIn Formulas and FunctionsHi Can someone help me to write these five formula in a single formula to get the schedule health. IF([email protected] = "Not Started", "Gray") IF([email protected] = "On Hold", "Yellow") IF([email protected] = "…Answered - Pending Review 2 views 3 comments 0 points Most recent by Toufong Vang Formulas and Functions
