Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Contact Lists and FormulasIn Formulas and FunctionsHello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-a…
-
COUNTIFS Formula "NOT" errorIn Formulas and FunctionsI want to calculate something for a dashboard. My formula references our team's tracker sheet. I am looking to use COUNTIFS for Tasks that are a specific Request Type, not a grand parent row, and not in our Archive section. The first part …
-
Extract a value if today is between start and end dateIn Formulas and FunctionsHi all, I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha) I have a schedule with 3 main columns - the name, the start date and the end date. What…
-
Need to sum numbers from a metric sheet to a rollup sheet for specific quarters/yearIn Formulas and FunctionsIs it possible to use a formula to sum the total of a column that meet a criteria? I'm trying to create a rollup sheet (from the data sheet) based on year/quarter. So I'd like to be able to use a formula. I need this to look at the Year an…
-
Date Range Comparison only for cells with the same value?In Formulas and FunctionsHello, can any one assist me with building a formula that will do flag a date range overlap for any cells that have the same resources allotted to them? I am basically trying to come up with a work around for not having admin rights nor th…
-
Convert to a date from a text-field Month numberIn Formulas and FunctionsHello Smart(sheet) Friends I have a smartsheet to record safety audit results based on audits in different locations from various teams. To re-use the same schedule each year without having to update, the schedule is listed Jan1H (1st ha…
-
Can OR function be used with cross-sheet references?In Formulas and FunctionsI'm trying to use OR with SUMIFS in a cross-sheet calculation but it doesn't work. As an example the formula below yields a INVALID OPERATION error. =SUMIFS({TotalCost}, {Cost Center}, [Cost Center]@row, OR({Reason} = "Other", {…
-
View All Formulas Used in a Particular SmartsheetIn Formulas and FunctionsI would like to see a list of all the different formulas that are used--along with which cells are affected by these formulas--on a particular smartsheet. Is there somewhere I can view this?
-
Is there a way to format individual text/characters within a cell?In Formulas and FunctionsAre you able to format only certain text/characters with an individual cell, or does formatting apply to all the text/characters within a cell? If I cannot format only certain characters, this would be a great recommendation for an enhance…
-
Notification on Formula or On StatusIn Formulas and FunctionsIt appears that it is not possible to send a notification based on a formula if the sheet has not been opened/saved. Is there a work around within Smartsheet? Is it possible to send a notification every day on any rows that have a particu…