-
Count(Children()) Not Counting Correctly
I am trying to create a rollup of the status of the phase using a modified version of the method from this post: The problem I am running into is somehow the simple COUNT(CHILDREN()) portion of my formula is not counting the correct number of children. As shown in this screenshot, there are clearly 3 children of this…
-
Using SumIFS and OR
Hi All, I am having some syntax issue that I can't get around. I have the following formula referencing a separate sheet. =SUMIFS({Closed Transaction Qty}, {Closed Line Category}, [Item Category]@row, {Closed Line Del.Yr}, Year@row, {Delivered Month}, [Month #]@row, OR({Load Dock Ind.}, ="A", {Load Dock Ind.}, ="NOS")) It…
-
How to extract just the month name from a date
Hi all, I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
-
5x5 risk calculation
Hello there Can anyone please tell me what I am doing wrong with this formula? it is a risk calculation. I think i am making an error with the between numbers if than makes sense. As in what but less than 7 for example. Your help would be greatly appreciated. =IF([Inherent Risk Factor]@row = ""; ""; IF([Inherent Risk…
-
Reference Data from report
Hi We have lots of project sheets which must be got their project end date. Then I use the sheet summary function to get that valuable information from every project sheet. Then I got a report of all project end dates. Unfortunately, a few projects don't use Smartsheet. So, I created a sheet and shared it with them to…
-
=If Formula for when "" to output ""
Hello Smartsheet Experts, I am new to Smartsheet and Syntax as a whole. I am in need of some assistance. I have a formula to change Mod 1 to "Beamline" if "Tool Number" is above 239000 and if below 239000 Mod 1 changes to "90" BUT when there is nothing entered in the tool number column I want the Mod 1 cell to clear if…
-
Calculating average % based on column value
I have some numbers coming in a column from a calculation. I am targeting 60 or less to be 100%. If the If> than 60, then this is 0%. I then want the average % for each month. Would anyone be able to assist with such formulla?
-
I would like to write the formula to create the JSON format .
I am unable to find any documentation for creating the formula to generate the JSON format ,Can you please help me if there is any documentation available. Actually the requirement is we have 10 column values and one JSON generator column ,Smartsheet should convert those 10 column values into JSON format after entering the…
-
Formula to retrieve a term code based on a date range
Hello everyone, I need a formula that will retrieve a Term Code from a helper sheet based on the date that a row is processed and insert it into a worksheet. The helper sheet has the Term Codes and it has columns for Start and End dates that apply to each Term Code. For example, the Term Code "2217" is valid for the period…
-
Formula(s) to highlight missing time submissions
Hello, I have a front-end form used to collect an employee's name, date, and login time each morning. The same form collects an employee's name, date, logout time and daily work log at the end of that same day, so each employee should have two rows created each day. Is there a formula that can cross-check the date field…