-
Removing System Generated column (Date) contents
I have completed building and testing my sheet and Dashboards. I now want to remove the System Generated Date for all my Form entries used for testing. If I remove the column and reinsert it, the formulas dont work. Is there a simple way of removing the system generated date data?
-
Formulas
Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.…
-
SUMIFS Statement under Parent Item
I need to Sum the "Total" column cells IF: 1) Column Department Allocation Code = "49 CONTINUOUS IMPROVEMENT: Formula: =SUMIFS(Total:Total, Department Allocation Code:Department Allocation Code, ="49 CONTINUOUS IMPROVEMENT", Item:Item, =PARENT(Item1)) *Not working <img alt="" data-entity-type="" data-entity-uuid=""…
-
"IF/AND" returning #INVALID DATA TYPE"
Hello, Guys Please, can you help me to fix this formula? =IF(AND([Start (plan)]4 < TODAY(); [Start (real)]4 = ""; "Red"); IF(AND([Start (plan)]4 = TODAY(); [Start (real)]4 = ""; "Yellow"); IF(AND([Start (plan)]4 > TODAY(); [Start (real)]4 = ""; "Green")))) It is returning "#INVALID DATA TYPE". The "Start (real)" and "Start…
-
Cross Sheet referencing
Hello, I have a master sheet, where I am keeping track of the progress of various tasks. The progress is being monitored using checkboxes. The structure of the sheet will be clearer through IMAGE A. Each project has it's own smartsheet and I would like to format the master sheet based on targets met in the individual…
-
WEEKDAY formula is giving me the wrong result
Ok, am I missing something obvious or is the formula not working properly? As shown in the image, the date is 6/2. Which is a Sunday. But when I use the "WEEKDAY" formula to reference the date column it keeps coming back with "2," indicating that it's Monday. What am I doing wrong?
-
#Invalid Operation
Hello, I have this formula: =IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE") I've tried a few things but I keep getting invalid operation, and I'm sure it's something foolish and easy but I can't seem to figure it out. Tahnk you-
-
Count Raised flags under child and grandchildren
Hello everyone, I am trying to wrap my head around this one and I'm sure others have too. I want to count all the Flags that are raised under a grandfather (Administration) : the children and their grandchildren. Currently my solution works, but it's weak. It depends on a fixed range, and as time goes on, new grandchildren…
-
Problem with SUMIFs second critera based upon date
Hello, Smartsheet example here: https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c2 What I am trying to do is the following: =SUMIFS(Name1:Name14, "Happy", average1:average14, Date1:Date14, >TODAY(-31)) / COUNTIFS(Name1:Name14, "Happy", Date1:Date14, >TODAY(-31)) Basically the following critera: *…
-
Auto-generating Google Campaign URLs with Smartsheet?
I would love to create and manage Google Campaign URLs with Smartsheet. Ideally, I would enter the URL and associated variables, and in the final column it would generate the complete campaign URL, just like the official Google URL builder (https://ga-dev-tools.appspot.com/campaign-url-builder/). Specifically, I suppose…