-
How do I count the number of times dates appear within a range?
Hi, I am trying to track the number of times a call occurs within a date range in a cross sheet reference formula. The user types the date on the call log and I would like to use the dates as a way to measure how many times calls occur within a week, month, and project to date . I have tried different ways, but I am stuck…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
How to have a Date and Time format for Date Column Properties?
Hi, Do we have Date and Time format now for Date columns?
-
Invalid value (Problem with RIGHT, SUBSTITUTE and VALUE Formula
Hello, As the picture below shows, I am trying to extract 2 numbers from a cell that displays different formats (paper sizes). I need to set up a calculation with the 2 numbers. That is why I use the LEFT and RIGHT Formula to extract the text and the VALUE formula to change it to number format. I also use the SUBSTITUTE…
-
Looking for Nested IF formula support, unless that's the wrong formula set...
Looking to get specific terms to auto-populate the "Production Status" column, based on where the current Actual production line up is done to. For example, if a date is entered (manually) for Capping Actual, then Production Status would say "Capped". If IVT/ Uncapped Actual had the last date it would say "IVT" for…
-
Why do the dates change in the fillable PDF?
Hello I am making fillable PDF and I was trying to put a birthday in them and when it loaded it came out as (Not real) 04/05/23. I have changed it in the smart sheet cells where the dates read out as April 5, 2023 but when it hits the fillable PDF it changes to just numbers. I need it to be spelled out does anyone know why…
-
Is there a way to track workflows
Recently, we have had a couple of team members claim that Smart Sheet did not send the automatic update request as part of a workflow. Is there any way to show when exactly smart sheet would have sent that out?
-
Help on Or/Contains formula
I am in the need of some help as I am banging my head against the wall trying different formula options here. I wish to grab all characters left of a certain character combination (" -") from a drop-down cell. For instance, I wish to grab "Hosted Event (physical)" from the drop-down cell with "Hosted Event (physical) -…
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
Can't compare two string values
So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too. I'm trying to pull the value in…
