-
Can I auto-populate a value from the parent row to the children row?
Hi I am building a product planning tool. I will have Initiatives, Epics, and User Stories, each will have a identifier Initiative: e.g. I-123, Epic: e.g. E-123, User Story: e.g. US-123. I would like to create two columns, column 1: auto-populates the Initiative number to all Epics and User Stories below it column 2:…
-
Dashboard date not updating from source sheet
Hi i have created a Dashboard that had a widget with the date. This changed automatically with the formula =today() from another source sheet. Since last week in dashboard this date stopped to update automatically and still is showing Jan 13, 2023, but the original source is showing today date. Any idea why this is…
-
Help with sumifs and date field
I have a formula that was correctly returning the sumifs of a column (gross) based on the deposit date in 2022 if in the current calendar month. Beginning this year, it is no longer returning data from this month. Not sure what is wrong. Here is data. Formula =SUMIFS({Gross Commission 1}, {Deposit Date},…
-
How to set a formula for 3 different values to prevent any duplication
Hello Everyone, I hope all are doing well. I'm facing an issue to find the suitable formula to my case taking into consideration i'm a newbie here in smartsheet and would appreciate your kind support. The formula i'm looking for is targeting 3 main columns : Start Date, End Date & Facilitator. To assure that if a…
-
Crosssheet Formula
Hello, I am trying to do a cross sheet formula. The formula below is what it looks like in the original sheet and the formula works. Now I want to pull the data from the original sheet into a new sheet and the cross referencing is not working. Any assistance would be greatly appreciated. Original sheet - works good…
-
Parent/Child row formula
What would be the formula to use for when you want to update the parent row with child row data? For example, if a subtask under the parent row is marked as 'In Progress,' I'd like for the parent row to be reflected as 'In Progress.' Thank you.
-
Using IF AND & OR in the same function
I've seen a couple questions involving AND and ORs separately but nothing involving them together with IF. I'm trying to get a checkbox to automatically check if the following criteria match: Self Survey Column is green Workshop Attended Column is checked off Evaluations Column is either "completed" or 5 or above. The…
-
Parent row to give a percentage when Child rows below are populated
Hello All Can anyone help me with a formula for my parent row below. I need to work out what percentage of days in a week I have booked out for our staff on projects. Currently I do this manually. As the only formula I have found have been for Tick boxes or completed tasks. The jobs are selected from a drop down list and…
-
Counting range of cells within row
I'm trying to count the amount of times a cell within a row has a specific word: =COUNTIF([Labelling)@row,[Training]@row), "Fail") If Fail shows in any cell I want the function to result a readout of 1. If two cells have Fail, then the result would be 2, etc. Instead of my expected result, I get #UNPARSEABLE in the cell.…
-
Formula for =text(A1, "000000-0" ?
I am looking for a similar Smartsheet formula that excel has that takes text from a column/cell; say 12345-7, and changes to "0012345-7" - forcing the cell to be in a specific format. Excel uses "=text(A1, "0000000-0")