Hi team, Can someone help me with this issue. This formula works: =COUNTIF({NL Daily Error Log Date}, >=[Start date month]@row) This formula does not work (invalid operation): =COUNTIFS({NL Daily Erro…
Hi community, I am using a sheet where a large number of people is asked to regularly add rows with data. My question is if there is any risk that if the group gets larger and larger, the rows that th…
Hi team, This is probably so obvious but i don't manage to get the following formula to work: =IF(AND({EMEA KPI General data Country} = Country@row, {EMEA KPI General data Payroll month} = Month@row),…
Hi team, I cannot get rid of the unparseable error for the following formula. I think the issue is the =[Month]@row and =[Country]@row. I have tried also without the brackets []. =SUMIFS({EMEA KPI Iss…
Hi community, i have a sheet with some values in the primary column called Month. They are expandable but when I create a report for this sheet the rows underneath e.g. April are of course blank. Is t…
Hi community, I have a lot of formulas in the sheet summary of my sheet. They all start like this "=COUNTIFS(Project1:Project149, NOT(@cell = "Epic Line"), [Row ID]1:[Row ID]149, ISNUMBER(@cell), ....…
Hi all, I am looking for a way to export my smartsheet data not to excel but to a powerpoint or other type of one pager solution that shows the data not in a table format but in some nice blocks etc. …
Hi group, I am trying to use a formula with a cross sheet reference but when the cross sheet reference form opens i only see about 5 columns of the 50 columns on the reference sheet and the ones i nee…