-
Troubleshooting Sheet Summary "INVALID DATA TYPE"
Hoping that the community can explain this issue I cannot solve (nor can AI). Today we added a Y2026 Savings column to our sheet. Column formulas were all updated as well to look for values with "effective dates" in their corresponding years. Sheet Summary (for Dashboard) formulas broke returning "INVALID DATA TYPE". Tried…
-
Why are my durations not calculating correctly, and how can I adjust this?
I'm working through a rather complicated column formula and ran into something that seems to be native to SmartSheet. It appears to be rather minor, but is throwing the whole thing off for me. If you look at the first row that has dates in it, for example, you'll see that the row starts on the 1st and lasts 10 working…
-
Undelete and Permissions
Hello, I am in desperate need of help! The AI is not helping so I hope there is some really smart people out there who can!! PROBLEM I mistakenly deleted the 4 primary sheets I have created and use daily. I tried to undelete the sheets and it is now telling me I do not have permissions. I was the admin, requested the…
-
Merged: longer sheet names
This discussion has been merged.
-
Merged: Provide option to remove popup windows
This discussion has been merged.
-
Ich habe eine Business Lizenz und möchte Berichte für Mitarbeiter freigeben.
Hallo. Ich bin noch nicht lange hier bei Smartsheet und habe einige Probleme zu verstehen, wie ich Mitarbeiter für von mir erstellte Bereiche oder Berichte zum Bearbeiten oder Betrachten freigeben kann, ohne kosten zu produzieren. Ich habe diverse Berichte für Kollegen als "Bearbeiter - kann nicht freigeben" freigegeben.…
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
-
Adding multiple columns at once
Hello, Based on a previous post I saw in regards to rows, I wouldn't be surprised if multiple columns cannot be added unless done one at a time, however if it is possible can someone please assist? I would like to add about 5 columns at the same time without having to add them individual and name each one at a time. Thank…
-
Receiving an Error Code when Creating Chart
Hi everyone! I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly). The formula I used in the metrics sheet is as follows: =SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant",…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…