- How do I autofill a formula to new rows that will be added via a web form?
Hi, I'm trying to have a formula autofill as new rows are entered into a project list sheet. I know smartsheet has an autofill formula feature, but I'm not sure how to use it. Is it an automatic thing by default, because if that's so, my formulas from the rows above are not autofilling in new rows created. Any help…
- Sum every other row
How do I add up values of all odd or all even rows? I've tried =SUMWIN(WIN1:WIN119,MOD(ROW(WIN1:WIN119)+1,2)) but it didn't work (WIN is the title of the column)
- Is there a way to auto-populate a field on a form to match the same field on another form?
I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial. I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit)…
- Time Formula
Hi there, I need a formula that will round UP time, for example if I have 2.5 hours worked I would need the column to round up to 3 hours. I have an hours worked column - 2.5, and a column of time paid (which needs to round up to the next hour, in this case again it would be 3). Thanks, Melissa K
- Checkbox Parent Cell if any Children cells are Checked
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
- Countif with Dates, Smartsheets keep adding blank lines, Invalid Data Results
Hi Guys, Firstly, thanks for the help. I am trying to add records and have cumulitive counts based on dates. I am counting the date column of the new input lines with the following formula: =COUNTIF([Created Date]:[Created Date], TODAY() - @cell < 7) for Records added in the last 7 days and: =COUNTIFS([Created…
- Formula Help!
Hi Everyone, I am needing help with a formula. I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint. Thanks for the help in advance.
- Is it possible to set due dates based on a formula?
Hello, I've imported an Excel sheet and my formulas aren't working. I'd like to automate due dates where the duration may change based on a numerical figure. For example, if there are 10 items to move, it will take 2 days for each of 4 tasks, but 100 items to move will take 5 days for each of 4 tasks. I've been playing…
- 30-Day Prompt
Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…
- Linking Sheets
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet. E.g: If in sheet 1, monthly payments are selected from the drop…
