-
Formula Help
Hi, I am trying to find a formula that finds the closest project board date following a milestone date. From the screen shot below I want to look at the dates in the second column and find the next board date from the cell highlighted in the finish column. Is there a way smartsheet can do this or will I have to do it…
-
SUMIFS referencing another sheet and [column]@row
Hi I'm trying to sort the data exported from Resource Manager into something I can put in my budget. The formula I'm trying is: =SUMIFS({Import sheet Range 1}:{Import sheet Range 1}; {Import sheet Range 2}:{Import sheet Range 2}; [Fas]@row; {Import sheet Range 3}:{Import sheet Range 3}; [Roll]@row, {Import sheet Range…
-
COUNTIFS / OR - INVALID DATA TYPE
Looking for your help, I'm trying to get the below formula to work. Let me know if you need additional information: =COUNTIFS({Albaugh, LLC - RICEFW Tracker Range 4}, [Primary Column]@row, {Albaugh, LLC - RICEFW Tracker Range 3}, "Release 1", OR({Albaugh, LLC - RICEFW Tracker Range 5}, "Yes", {Albaugh, LLC - RICEFW Tracker…
-
Document generation not working for all rows
Hi, I'm attempting to generate a document based on the agreement trigger checkbox column (which is checked when there is a date in the event approval date). The issue I'm encountering is that for some rows, the document is generated and attached, but for others, it is not attached. Can someone help me to solve this?
-
Export as XLS with multi-select answers in different columns?
I want to export a sheet into XLS. I want all my columns that are multi-select to export as separate columns. For example, instead of one column "What kinds of animals do you like" and all selected answers appear in the subsequent cells, I want three columns "Cats," "Dogs," and "Rabbits" and a Y/N indicator in the…
-
Change Value in Symbol Column Based on Value of Other Column
Hello everyone! I have a Status column (Symbol type), where users can choose manually the desired status. I also have a Completed% column (Text/Number type), where a percentage is entered manually. I would like to change the value of the Status column to "Blue" when Completed% is "100%", but keep as is in all other…
-
COUNT formula not working on form submissions due to row numbers changing
Hello, I am trying to use COUNT to keep a running /live tally of requests that have not been closed yet in a Form driven sheet. Every time a customer enters a new request, row #1, is no longer row #1, and it breaks my formula, whereas, it will not include that new customer submission into the formula. Locking the row does…
-
How to parse out part of a repeated phrase within a cell
I have created a new column called "Workstreams" that has a "CONTAINS" formula @row that parses workstream names out of a "tags" column. (The cell in that row and in that tag column has multiple tags that the CONTAIN formula is parsing into my Workstreams column.) It works great until one of my workstream tag names is also…
-
Formula for past dates
Hi All, What's formula can I use to workout past dates, based on below example. Thanks in advance,
-
google contents of a cell
I use smartsheet to track Fedex shipments and billings to clients. One column has the fedex tracking numbers. Currently if I need to track, I go to the column, copy the tracking number, open a new chrome browser window and paste it in and with one additional click I get tracking data. Is there a way to make every entry in…