-
Auto-populate a form field with the result of a formula in the sheet.
I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe Iโฆ
-
Backtracking Formula Origination - "Cost#"
Has anyone ever used or seen "Cost#" used in a formula? I'm not sure what it's referencing, but it doesn't look like anything specific to my sheet. Any insight is greatly appreciated!
-
WeekNumber & WeekDay error
Can anyone help with a way round the weeknum formula that starts on a Monday rather than a Sunday? I'm using the WeekNumber formula to get a current week in conjunction with the WeekDay formula to create a list of tasks due in a current week sorted by days. Because the dates for when each task is due is auto populatedโฆ
-
Formula to pull in fiscal work week is incorrect
I am continually getting the incorrect work week. In the below screen shot the Onboarded Week should be Week 16. Attached is our lookup sheet from smartsheet. Our fiscal week starts on Saturday, January 29, 2022 and the fiscal week ends on Friday, February 4, 2022. the pattern is 4,4,5 (kinda) you can see it gets a littleโฆ
-
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โฆ
-
Automatic Duration column calculation + Linked Dates, is this possible?
Is it possible to have a "Duration" column that automatically calculates duration days based on End Dates that are linked to another sheet? For context these are my 2 scenarios: One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.โฆ
-
Is it possible to attribute all levels of child rows to the same parent hierarchy?
I have a Project Plan with multiple levels of hierarchy, but I'd like to have a column formula that would tie everything to its relevant parent. Essentially what I am looking for is a formula for the Project Column below where even the grandchild or great-grandchild tasks associate to the highest level parent w/in theโฆ
-
Attempting to count the total of two drop down menus
Hello, I have two drop down menus, one has company A, company B, Company C. the other drop down menu has option A, option B, option C. I need a cell to tally how many times company A gets option A, B, or C, how many times company B gets option A, B, or C etc. currently I am using =countifs formula which works with optionโฆ
-
Countifs formula question
Hello, I am trying to pull the data from a column in one sheet to another sheet and count how many "lates" there are. The column I'm working with has the formula and covers 66 rows: =IF([Date Opened]@row + 30 < [Date Closed]@row, "Late", "") Is there a way to have the "lates" counted and that new data shown in my newโฆ
-
Creating a Pareto of data in multiple columns
I am analyzing data pertaining to manufacturing defects (example below), and cannot seem to summarize the defect codes into an organized Pareto. Feel like I may be missing something, as I'm pretty new to Smartsheet. I can do a sheet summary, but that will not allow me to generate any type of visual chart.