-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
-
Calculating Totals
Hi all, Im trying to use a formula to calculate how man hours of different leave type an employee uses to add to a report and or dashboard. Any suggestions on how to make that happen?
-
"WBS Helper Columns->" column
Does anybody know what the "WBS Helper Columns->" column does in the Project with Work Breakdown Schedule (WBS) template? Is it just a helper column where a function could reside, or does it have an "Off the Shelf" purpose?
-
"Helpful" Popups
There should be a way to hide tips and tricks from Smartsheet. If you have been working with formulas for years, you should be able to type in a formula without a pop up that blocks the other cells telling you how to use the =SUM() for example. It is always in the way of the cells I need to select. Should automatically…
-
Allow for Smartsheet to pull and return column names into a formula
Unlike some other spreadsheet programs, Smartsheet formulas cannot reference the actual header row (row 0) as data. I have a sheet which tracks many dates pertaining to our projects. Each column is named for the relevant milestone. I built a column formula that can iterate over those columns and pull the most recent date…
-
IF Formula working on some and not on other items in column
Hi All, I have a formula running in a column to validate an action based on whether it was done prior to 01/01/2011 or not. =IF([Install Date]@row >= 1 / 1 / 11, "Yes", "No") The formula works as required on rows where there is a year only, but throws #INVALID OPERATION where a date has been entered through smartsheets…
-
Construction Phase Count Formula
I'm trying to count how many projects are in the construction phase each month using this formula: =COUNTIFS({Master Project List Range 1}, "2 - Construction", {Master Project List Range 2}, <=Month@row, {Master Project List Range 3}, >=Month@row) It works, but I want to make sure it's also counting projects that are…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Calculating SUMs based on Criteria 1 and 2
I am trying to calculate the total cost if Agency = X and if Status = Converted, take Total Spend - i've tried it a few ways but its just returning errors Here's my most recent one: =IF([Total Cost for Converted]@row <> "", [Total Cost Overall]@row + IF(CONTAINS("Converted", {Status Range}), {Estimated Travel Spend}, 0),…