-
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…
-
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…