-
Dependencies choking date formulas
Is there any work around to keep date dependencies and still run calculations using those columns? Before dependencies were enabled my formulas worked fine to support my dashboard. Do we need additional helper columns? =COUNTIFS({IMPACT}, Metric@row, {END} >=(2021, 10, 1), {END} <=(2021, 12,31), {STAT}, "In process")
-
Formula with two column dates and show the higher
Hi good day. I have a sheet with 2 column dates. "Mitigations date 1" and "Mitigation date 2", i need a formula in a third column that shows me the higher in these 2 columns. If Mit 1 is higher then show that if Mit 2 is higher then show Mit 2. That column will be my column to show in an dashboard items with past due…
-
#Invalid Data Type with VLOOKUP
Good day everyone, I'm trying to use the formula VLOOKUP to pull some information from another sheets, but it shows me #Invalid Data Type. I have this sheet named "2020 vs 2021 P/Month" and I need the formula to look for revenue on sheet "Rev By Month P/BTC 2020", so when I fill this last one, fills up the information to…
-
Formula to copy Child data to Parent
Hi, I would like to copy the child data to the parent and want to convert it into a column formula. Is it possible for the below scenario? Also, for the below I want for Parent cell from Child, I tried =MAX(CHILDREN([Close Date (SF)]@row)), can I convert that into a column formula to get all the Parent cells filled…
-
Dynamic Forms
Hello I have my project plan with certain people assigned to tasks. Each week i would like to have everyone fill out the percentage they are complete on the tasks that are associated with the week via form. I was wondering if in the forms i could have the user select their name from a drop down then see all the tasks they…
-
Count If Unique
Hi! I'm trying to figure out how to do a Count If Unique formula in Smartsheet. I know I can use the Distinct function in replace of the Unique function, but I need it to Count a specific criteria from another column? Thanks! Melissa
-
Want to Calculate the Number of days a task is in OPEN status
When the status changes from Open to In-progress the calculation gets reset to 0 days, Please Guide Thanks!
-
Forms with formulas
I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to…
-
Formula to calculate checkboxes per row?
I have a smartsheet that is currently used to track assignments to staff members. Data is input via a form, those rows are added to the bottom of sheet and I have columns with formulas that track how many assignments each person gets and of what "type". What I would like to do but haven't figured out how: each row has a…
-
Remove the "0" in the column formula cell.
Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column. See formula in Screenshot and the cells…