-
Using Contents from one Date cell to update another Date cell
Im trying to use a 'helper column' to run a formula that checks the contents of a date column/cell, and copies those contents to another date column/cell. The code I'm using is quite simple, so I feel that I must be making a silly error, or it is not possible. To re-iterate, I have a cell specific date column , and I want…
-
Formula IF print the date modification of the sheet by the leader.
I want to create an IF formula that will print the date and time of the modification of the sheet only by the leader. It is possible ? Unless there is another formula or method for that ??
-
Use IF/AND or INDEX/MATCH?
I have a sheet (top) where Site Code and Sub-GL are drop downs. There are hundreds of corresponding site/sub-GLs listed in my reference sheet (bottom). I am looking for the correct formula to return value of "2021 OP2 Total" when Site Code and Sub-GLs are selected match a line in the reference sheet. I can't seem to make a…
-
Sumifs with Multi Select DropDowns
Hi all, this is very simple, but I am pulling my hair out! I am trying to do a SumIfs, where one of the criteria is a multi select dropdown. My first attempt is =sumifs({column to be totaled}, {Multi select Column}, Option 1) If I do this, then it only Suns when Option 1 is the only option, not where option 1 and and any…
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
-
Contains "Kansas" is returning TRUE when actually contains ARKANSAS
My State field is multi-select and users can select: Kansas or Arkansas or Kansas and Arkansas or other. I want to return a text value "Is Kansas" in a separate column if the State column contains Kansas or contains Kansas and Arkansas but will not return "Is Kansas" if the State column has only Arkansas (or other). When I…
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
Blank Rows
We have a simple ticket tracking sheet. It consists of a couple dozen columns and one form. It don't use any hierarchy, so all rows are at same level. There are several columns that use formulas - some cross sheet vlookups, some date calculations, turnaround time, etc. Nothing too complicated, however, the formulas in…
-
IF, RYG and range
Hi All, I'm growing absolutely desperate. I have gone through what feels like a milion various posts on here, but nothing quite seems to answer what I need. I am trying to set up RYG conditions based on monthly estimated FTEs so that if the FTE is higher than 1 in any of the columns, the ball goes red. And I am wondering…
-
My Formula looks incorrect
Hello, I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something? I need to get my The formula I am using in smartsheet: =IF(ISBLANK([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "",…