-
Looking for the most recent date
Hi there, We have a internal learning courses that people can do to earn 'badges', there is approx 14 badges, each badge has around 5 units that need to be completed. When a unit is completed the person fills out a form which goes into a smartsheet to then be sent to an approver (once approved info gets sent to sheets for…
-
How Can I Create a "Stamp" of An Original Value?
Hi - I'm trying to create a rule/process whereby every time a row gets added (not changed), another cell gets "stamped" with the value. This is so I can have the stamped column as a reference of the Original value. In my scenario, it's a Total. So a row will get added, and in that row is a Total Column. I want to create a…
-
Updating Sheets Dynamically off Master Sheet
Hi! I am trying to create a solution for one of my clients and am hitting a mental roadblock. What I'm trying to do is simply update multiple sheets based on adding a row to the Master Sheet. I don't want to use the Copy Rows function for a few reasons, and this would be something I could solve with a Report, but I can't…
-
Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates? It seems like this should be…
-
Percentage Complete of child tasks
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete of child groups in the parent row. Note that I am not using dependencies, and am using an independent "% complete" column (I…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
How to calculate hours for tasks marked 100%?
Hello, In my Sheet I have a column for Task % Complete and another column for Total ETS Effort. The Total ETS Effort column contains the number of hours associated with each task. I'm trying to figure out a formula that would give me the total number of hours for each task that is 100% complete. Any help would be greatly…
-
Project Completion %
Hi! I am pretty new to Smartsheet and am building my first project template. I've got tasks in rows 21-169 and I am trying to build a formula to calculate the total completion of the project, taking into account the durations set for each row. The rows are also indented into phases and milestones. Any help or direction is…
-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…
-
Decrement a funding total
Hello all you formula wizards ~ I'm down to the last test of a travel request module and I realize my formula is not working correctly so I'm looking for some guidance. I have an intake sheet where requests are submitted, then reviewed and approved, which moves the data to another sheet for further approvals. I need to be…
