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
-
Need help understanding helper columnIn Formulas and FunctionsGood afternoon, I will like to understand why the result from =Right([email protected],8) time to time change to -3 hrs and them goes back to the time was created.
-
Send Update RequestsIn Formulas and FunctionsI deleted an automated "Send Update Requests" that I set up but for some reason it is still sending notifications to people. How can I undo that even tho I can't see where its coming from
-
Add data to existing sheet from mobileIn Formulas and FunctionsI am the only user of a budget tracking sheet. I'm looking for an easy way to add data (# of hours worked) to specific rows in the existing sheet. For example, I have a row for Task #1 which I'll work on various days in a month. Each day I…
-
Compare two Smartsheets to see if a customer is missingIn Formulas and FunctionsI have two Smartsheets. The "main" Smartsheet that is copied/pasted to update customer list and information weekly and then another Smartsheet that uses VLOOKUP on the customer ID to pull in necessary data for that sheet, where …
-
Greatest Common DemoninatorIn Formulas and FunctionsIs there a formula on how to find the greatest common denominator between two cells?
-
Health status symbolsIn Formulas and FunctionsGood Day! I would like to automatically set the health status of my projects. I have this Erro Message: ''UNPARSEABLE'' Below is the formula: =IF([email protected] = "Analyse"; IF(NOT(ISBLANK([DateRéception DC SAM]@cell;"Gris"…
-
SUMIF from a date plus 7 days backIn Formulas and FunctionsI'm trying to total the current week in one field and the previous week in a second field. The reference sheet lists every date of the year in one column and the amount of transports for each date in another column, along with a lot of ot…
-
COUNTIFS with Parents/Childrens AND/OR and multiple columnsIn Formulas and FunctionsHello, I have spent HOURS on this and help. This for "Invoice/Sheet Received" Parent column with drop downs. I am combing the Parent code AND child codes so can click+drag it down my sheet. I want to keep this. So the firs…
-
Formula to clear in certain fields of a rowIn Formulas and FunctionsI have a smartsheet for a workflow. If at some point there is a change order, then the workflow needs to start back at the beginning and most of the populated cells need to be cleared out. Is there a formula to make this automatically ha…
-
Help with SUMIFS formula to display todays censusIn Formulas and FunctionsHello, Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census. I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'to…