-
COUNTIF problem with OR / " INVALID DATA TYPE "
Hi all , Can you tell me what's wrong with this formula : COUNTIFS({Catégorie_courrier}; ="Permis"; OR({COURRIER_Réponse}; ="Oui"; {Traitement_demande}; ="Oui")) It returns the error message : " INVALID DATA TYPE " . As {Catégorie_courrier} , {COURRIER_Réponse} and {Traitement_demande} are 3 ranges each corresponding to a…
-
CTRL + D not working
CTRL + D used to let me drag cells, but now it just clears them. Anyone else having this problem?
-
Using Zapier to Move Rows
When a person submits a complaint it goes to the bottom of our sheet. If it's identified in a certain column, I'm wanting it to go under a certain category. Like we have a row for "Escalated Issues," "Minor Issues," "Non Issues." If a person flags an issue as "Escalated" I'm wanting it to fall under that Parent.
-
Reminders/Alerts based on Date
Greetings, I know there are new workflows, but I'm trying to create a complaint system inside of Smartsheet. One thing I'm trying to do is setup something based on the date the row was created. Example If row is created on 06/02/2019 then notifications is sent out to the people that are tied to the Category. (I'm still…
-
RYG Formatting on New Row - From Form
Just a quick question, I'm noticing that when a form submits a new row it is now carrying down the Symbol's column or formula I have in that column, Anyway to get that to carry over? I have a feeling I might have to look at Zapier.
-
RYG Status When Row is Complete
Greetings, I'm working on a complaint tracker and I'm trying to come up with a solution to this issue. I'm using a status RYG column that is tied into the Date Created. The problem is, when the row is "Complete" and I've created a condition to mark out the row when completed.. But the Status still ages with the date. I'm…
-
Automated backups of sheets using tool
So I'm using the Smartsheet backup tool on a linux server, it's very simply and looks great, you modify the properties file, run the jar and there's your backup. I'm trying to automate this backup using Crontab but it seems like the backup tool looks for the properties file from your current directory, obviously in…
-
Form help - one field per row??
Is there no way for multiple small fields to appear on the same line? I'm wracking my head for what feels like a simple issue... Building an entry form and want a section to look something like (ease of use). Field A [_____________________] Field B Field C [________] [_______] -instead of- Field A [_____________________]…
-
Smartsheet export to excel corruption error
My team has been exporting a Smartsheet to Excel for over a year now then 5/30 we started getting a corrpuption error on our export to Excel (see attached Corruption1 & 2 Attachments). Trying to firgure out why this is happening now. I submitted a help ticket to Smartsheets however they miss read and assumed i was trying…
-
timing of the Run workflow:Daily ?
Hello, If I set the change action like below with "Run workflow:Daily", how the recurrence occurs? lets say, the requests come in at 9am, 11am, 3pm, 4pm, 9pm on the day, how the run works on the day and next day? Thanks, Hana
