-
Specific cell reference in update request text
Hello! My examples are in French, but as SS is the same, you should understand with the visuals. I used a template as a base for my project management office. In this example, we create a folder with the project name, but all the subfolders remain “generic” in order for the links between them to continue working if we make…
-
how to omit 0 in graphs in a dashboard for a cleaner look
hi! I want my graph to only show values greater than 0. I've tried cleaning up my rows by adding a formula to leave cells blank if the value is zero. however, when I add the graph to my dashboard all values are showing and it looks really messy. this graph comes from different values but just to get a visual
-
Index Collect with Dates
Hi, I'm looking to get a bunch of different outputs based on: 1) an account being the smallest/largest (min(contract spend)) 2) an account being in a given month ({Assigned Date}, IFERROR(MONTH(@cell), 0) = MONTH([Month (just update top row)]@row)) 3) various other variables such as customer segment, etc The thing is, I…
-
tryin to if function with OR and AND
Hi All, If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected if the 'Date found' column is blank, column7=blank Can anyone please try help @Genevieve P. @Paul Newcome can you…
-
SUMIFS when a column is not blank
I have multiple sheets that I am working from where I need to sumifs a column only if another column in the same row is not blank. This is what I want to do: If {Column C} is Blank or more than 0, Sumifs {Column B}, if {Column A} is checked This is what I've tried: =IF(SUMIFS({Column C}) < 0, "", SUMIFS({Column B}, {Column…
-
How to enter a formula referencing other cells within Duration?
Hello, I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the…
-
what is the wrong with this
=IF(AND([total]@row = 100, TODAY(0) < [done]@row), "qualified", IF(AND([total]@row < 100, TODAY(0)< [done]@row), "under-qualification", IF(AND([total]@row < 100, TODAY(0) > [done]@row), "not-qualified"))))
-
Resource Forecasting formula
Dear all, I hope someone can help me; I have a large sheet with a row per resource and a set of 4 columns repeating for each week of the year. The first column of the 4 has a week commencing date; this is dynamic based on a start date I enter into a reference cell. The second column in the repeating columns derives the…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
I need to add the number of days in one cell to start date and it needs to be in workdays
I have one column with my start dates and a second column with a varying number of days that need to be added to the start date, and I want the resultant date to be in workdays. I have tried various formulas and have not been able to find one that pulls the value in the second column to add to the start date. Suggestions?
