-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…
-
How to Add Categories in Personal Budget Management Template
Hello. I am new-ish to SmartSheet. I am wondering if anyone can help me understand how to add more budget categories to the existing Personal Budget Management project template (specifically trying to add categories to the "Budget Setup" sheet in a way that keeps the formulas in tact... currently only a certain number of…
-
Sheet summary to populate date in sheet
Hi all, I'm currently creating a template to monitor store closures and need some support in setting up a way to populate a date from the sheet summary. The end goal is to when in use, to be able to populate the date for the activity to start and able to flag any outstanding points after 30 days. We are able to populate…
-
COUNTIFS formula question
I'm trying to count items on a sheet if they meet a certain criteria and contain a name and put that value on a different sheet. I'm using this formula =COUNTIFS({MT Rollup Sheet IT Lead}, CONTAINS($Label@row), AND {MT Rollup Sheet Project Status}, "Active") and receive an UNPARSED error. I want to count how many active…
-
Why is my Excel exported from a report empty?
Hello, I am trying to solve an issue I am having with exporting data from a report to an Excel sheet. We have a financial report that is exported to Excel on a weekly basis. This week when our employee went to create an Excel export of this report, the excel had no data and only showed header names. I tried exporting this…
-
Help Article updates
Hello Community, We’ve added a Video Tutorials page to help you dig deeper into some areas of Smartsheet. Read on to learn more about some of the content that is now available to you. Learning tracks recently launched or updated: Data Shuttle Learning Track Resource Management Learning Track To view the full catalog of…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
How Do I Sum Up Values from One Sheet to Another With Different Criteria?
Starting with the basic of, how do I populate from one sheet to another while adding a running total? The next layer to this is, how can I get different sub sections to specifically populate into another sheet. In my photo you'll see "Parent Node F" with a total footage in bold and a delta (Production Master). In the other…
-
Count IF Question - Running Count
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Name]$1:[Creative Name]@row, [Creative Name]@row) Please Note: Sheet A Creative Name = Sheet B Ad Name Sheet B is generated…
