Is there any way to change the location of the labels on a stacked graph? They appear to the right of the bar and with multiple items in the stack, it is misleading as to what the label represents. Se…
Hi, I am hoping to see if I can get help with the following formula: =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], …
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Pare…
I have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it does…
We have started using the grouping function within several reports and grouping on a date field but we are coming across tasks with the same dates not appearing within the same grouping? We are not gr…
I know there has to be a simple way to do this but I'm not finding it and I getting into crunch time on this project so, HELP! :) I have a sheet that has a bunch of projects on it. I am pulling a repo…
I am receiving the #UNPARSEABLE message for the following formula to reflect length of stay between two entered dates using =IFDATED([MOVE-IN DATE]1,[ASSESSMENT DATE]1,"Y") & " Yrs, " & DATEDIF([MOVE-…
Hello, I am trying to have a column that calculates a fiscal year automatically based on whether the parent Completed Date falls before or after July 1. Something that follows this logic: If the paren…
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome th…
I'm trying to shift our company towards using reports more, instead of multiple people interacting with sheets directly (and thus making version control difficult when minor items are changed, particu…