How to I calculate percentage progress in sheet summary based on status?
需要帮助在这个简单的公式for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
Hi all, First post but I've been reading (and making use of!) many of the queries & answers for a while. Stuck on this one! I have two JOIN(DISTINCT(COLLECT formulas that I am adding together, but sometimes the same person's name will appear twice due to being pulled through by both formulas. How do I prevent this type of…
Is it possible to SUMIF a $ value column, based on a "this month" check box in Sheet Summary? I', using [Value]:[Value] and [This month?]:[This month?] for my columns. Thanks! Jen
I am in the process of changing everything over to Smartsheet from another package, and am having a great experience so far. I did have a question for experienced users that has to do with best practices when displaying information on a dashboard though: Is it better to have a helper sheet, or use the Sheet Summary for…
Hi, We use control center and we love using Sheet Summary field to bring in certain values from Specific Sheet (using cross-sheet reference formula) then we feed that info to column with column formula so every row will have the same info. We noticed we can't do this for Multi-Select Contact in Sheet Summary if column type…
I am trying to get the SUM of SaaS Value if the value in the Backlog Status column is Active Backlog. Tried this and I am getting unparseable SUMIF([Backlog Status]:[Backlog Status],”Inactive Backlog”, [SaaS Value]:[SaaS Value])
I'd like to be able to stop New entries from being submitted based on a date (similar to preventing changes to existing entries). This date could reside in a Sheet Summary field and be referenced in DV Logic. Sheet Summary fields in logic would be helpful.
Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect. The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct) I tried this formula on a second sheet and still received an incorrect…
