Formulas
Discussion List
- 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 curr…
- 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 co…
- 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 …
- 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 o…
- 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 …
- 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 colum…
- 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.…
- 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 Open…
- 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…
- 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 t…
