-
Sum cost in row based on current date
I have a sheet that contains costs for various projects spread out across multiple quarters for 2 years. I'm trying to find a formula that will calculate [Billed to Date] in each row based on the current date. See attached example sheet. Essentially the cells in the [Billed to Date] column will update automatically each…
-
Manual Copy and Paste of rows fails to paste formulas and hierarchy
About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using CMD+C and CMD+V (I am on a mac) and paste them into the new sheet. I am able to select…
-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
How do I remove the text between the second set of parenthesis in a cell?
for example: Tinley Park North (IL) FSU (Tinley Park, IL). Input: Tinley Park North (IL) FSU (Tinley Park, IL) Desired Output: Tinley Park North (IL) FSU I need a formula that can return the desired output but if false then returns the original value of the cell.
-
Formula Help
Hello, I have built the following formula but for some reason the last part of the formula is pulling a blank result, can anyone see what I have done wrong please? If the result is 12 and Internal it pulls blank instead of Creds / prior slides. Everything else works. Thank you. =IF(AND([Total Score]@row >= 35, [Total…
-
Automated Allocation - based on selected attributes
Hello Smartheads! I have a pretty interesting use-case. Columns look like in the screeen below: E Entry Number - values can duplicate Desired outcome: Trigger: Auditor selects her/his user ID in column C Audotor in a row. Outcome: After changing one row, the same user ID will be populated in Auditor column, if ENTRY NUMBER…
-
Formulas in Automations
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
-
HAS function with multiple valid choices
I have created the following formula to calculate aging for a row that has not been completed: =IF(AND(HAS([Issue Status]@row, "Pending FWCI Triage", "Pending DC Fix", "Pending Fix", "JIRA Ticket Opened")), [Date Issue Closed]@row = "", NETWORKDAYS(Date@row, TODAY())) The test criteria I used is the following: Positive:…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Good afternoon, I have been spinning my wheels trying to get my formula to work and scouring the community. Hope someone here can help :) I have employees that need to checkout items and they record this by form. My want is to pull the most recent date based on name and whatever item they checked out. Sheet A w/ the form…