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
-
Date changes to tomorrow after 5pmIn Formulas and FunctionsHello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date…
-
Multiple Countifs and Children to use in a DashboardIn Formulas and FunctionsHello Everyone! I'm new to figuring out counts in SmartSheets and Dashboads/Sights and could use a little help. I have a sheet that is connected to Salesforce via the Salesforce Connector, so the data is dynamic. I currently have the sh…
-
SumIf contains certain text--use FIND?In Formulas and FunctionsSorry, I tried to search the archives but couldn't follow the examples so am hoping someone could help me with this specific scenario. I am trying to put together a budget that is summing up columns that contain certain text. I would like …
-
formula helpIn Formulas and Functionsi need help with a formula please. my current formula looks like this.. =SUMIF(Stage:Stage, ???, [Job Value]:[Job Value]) i need an answer to the ??? please as it is a column that has a formula in it that relates to other fields an…
-
How to create an auto incrementing number based upon checkboxIn Formulas and FunctionsHi everyone, I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Installs this yea…
-
SUMIF IF referred sheet/column ISDATEIn Formulas and FunctionsHey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, [email protected], {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell…
-
Divide by Zero errorIn Formulas and FunctionsHello, I have the following formula to calculate % Over/Under Budget: =[$ (Over)/Under Budget]8 / [FOOD BUDGET July 2018]8 I would like this to work even when there is a 0 in the Budget number and even when "over/under" is …
-
Bug: EXTREMELY bizarre behaviorIn Formulas and FunctionsAfter the release a little while ago, the first thing I noticed was a simple sum of 7 cells was giving the incorrect value. That resolved itself when I closed and reopened the Sheet for the second time. And then the KPI's I was working on…
-
Check In/Out inventory logIn Formulas and FunctionsHello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveawa…
-
Importing Excel formulas "#UNPARSEABLE"In Formulas and FunctionsWhen trying to import Excel including following formula: =IFS(J3<0,2;1;J3<0,4;2;J3<0,6;3;J3<0,8;4;J3<=1;5) I get and error message in Smartsheet. #UNPARSEABLE" Following show up in Smartsheet. =_XLFN.IFS([Growth …
