-
Extract a value if today is between start and end date
Hi 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 I was hoping to do was extract who is currently scheduled if today was equal greaterโฆ
-
Formula to Average a Children
Hello, I have a column of costs that i want to average in a parent row, however I only want to average values that are greater than $0.00 and have an active status (seperate column). Below is an example. Status Cost Parent Row Active X.XX Child Row1 Active $4.00 Child Row2 Inactive $4.00 Child Row3 Active $2.00 Child Row4โฆ
-
Calculating a Running Balance
Hello, everyone! I'm currently working on an inventory system that is linked to one "Master Inventory" sheet. I don't know how to best create a "running balance" so that every time an item is scanned and an order is generated, the item's "Master Inventory Record" is deleted accordingly. Here is an example of the "Masterโฆ
-
If there are duplicates for a corresponding Primary Column, I want computation to appear only once
Hi, I am trying to find, how many Promotions are for a particular item for a particular Start Date. Example: Promotion || Total Number of Promotions for Start Date || Start_Date Bacon || 1 || 2/4/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 1 || 2/14/2020 Above tableโฆ
-
Forms and Formulas - Form add a row to top but formula does not include
I have a smartsheet that I want to use for team holiday requests.The team would fill in a form that add their request to the top of the smartsheet. Further down the smartsheet is a summary, by team member, of their total holiday allowance, calculated by formula of the number of days requested (and approved) and number ofโฆ
-
IF(AND) Statement With List of Expressions
Hello, I'm a fairly new user to Smartsheet and trying to put together some formulas. I'm currently trying to implement a formula to summarize a column called Status if the rest of the cells in that column have a "Complete" entered in them. If there is at least one cell with anything other than "Complete", I wantโฆ
-
GENERATING WEEKLY REPORT FORMULA
I would like to know what formula should I use if I want to produce a weekly report from this database? So the client wants us to give weekly report containing total number of request received for the week, also how many were completed, still pending or on going. (This is just the sample data as reference). Also, whatโฆ
-
COUNTIF AND CONTAINS FORMULA
Hi. I need an urgent help on my concern. Below is my sample database (because the real one contains around 500 plus area). So I need to count how many specific area was mentioned in the "Area Column" The count shall appear on the "Total Count" column. I want a formula that will reference to "Area Count" to count in theโฆ
-
Notification on Formula or On Status
It 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 particular status (e.g., Open)? It seems there is no trigger (no row change/add). TIA
-
Max Collect function not working with date
Hey, Ive got a drivers record sheet. on the sheet the date is entered and there are columns for the driver name and the asset number. Im trying to return the date for the last time a prestart report was done on a particular asset number. =MAX(COLLECT({Daily Driver Records Range 2}, {Daily Driver Records Range 1},โฆ