-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
Calculating SUMs based on Criteria 1 and 2
I am trying to calculate the total cost if Agency = X and if Status = Converted, take Total Spend - i've tried it a few ways but its just returning errors Here's my most recent one: =IF([Total Cost for Converted]@row <> "", [Total Cost Overall]@row + IF(CONTAINS("Converted", {Status Range}), {Estimated Travel Spend}, 0),…
-
Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
-
Formula shows UNPARSABLE
I am trying to create a formula, and I keep ending up with unparsable. The name of the field I am accessing is called "Deliverable Number". Now For example, this field contains 2 characters I want to REMOVE Original: DEL #10 - TO Portal Strategy/Solution Desired: DEL 10 TO Portal Strategy/Solution As you can see the "#"…
-
Add Centralized Date/Time or Changeable time zone on System generated columns
Please use UTC or a changeable time zone for columns which are system-generated. I have a sheet where I transform the "Created" column which is in UTC to a date in EST for readability. The discussion user however is in PST. That changes the "Created" column which in turn changes the transformed column. Normally, this would…
-
Need to update a formula to match items from multiple columns
I have a project currently piloting to update census numbers in animal cages. The formula I have pulls from another sheet and populates the data into the rooms of the same name. The problem I have discovered is there are some spaces that have two cage types we track, but my formula does not account for this. This is what…
-
Using SumIfs with a date qualification
Hi Everyone. I would appreciate any feedback on what I'm doing wrong. In the formula below, when I hardcode my dates below, I get the correct answer back. =SUMIFS({Tech Enablement-NCAL - Allocation}, {Tech Enablement-NCAL - Timeline Range 1}, HAS(@cell, $Resource@row), {Tech Enablement-NCAL - StartDate}, <=DATE(2026, 4,…
-
Google Map + Longitude & Latitude
I have a column in which I am trying to join a URL and two columns, one for Long, one for Lat. My goal is to write a formula to join them (i've tried, join, i've tried +)…. so that I can click on the link and be taking to the google map for the site. The issue is, the first coordinate is followed by a comma and the second…
-
Same Formula (=WEEKNUMBER(Date@row)) Different Result
Hello, Smartsheet Gurus! I am stumped. I am using the same =WEEKNUMBER(Date@row) formula in two different sheets. One sheet is pulling information from the other using the project number, employee name, and week number. I could not figure out why the data is wasn't pulling over because I used the same setup over and over…
-
Help with INDEX/COLLECT with a MAX/COLLECT
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would like to use the row with the MAX Fully Executed Date. Below is the formula I am using: =INDEX(COLLECT({IA Assigned}, {RTO…