-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Notifications or Alerts based on Conditions
The more and more I use Smartsheet the more I am becoming disappointed with the lack of features for something that has been around as long as it has. We recently chose to use Smartsheet and as long as we keep it very basic, Smartsheet is a "good" tool. I tried to use it for some basic excel things this weekend and almost…
-
Multiplication with results of an IF Statement
Hello, It appears you can't do calculations with the results of a nested IF statement? =(IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))) * [Number]1 It appears I have to have the IF statement alone in one column, and then the math in another column. =IF([Shift Duration]1 = "2…
-
Man hours & working out hours worked for a specific employee
Hey everyone, I'm new to this. Here's my sheet for reference. https://app.smartsheet.com/sheets/H5CQ6ffqh3x28mf265WJQqP5jqxvcjfHGFjcxHJ1?view=gantt Two things. 1. I want to have a man hours column that works out how many people are in the assigned to column (I've used people's initials) and multiplies that by the duration…
-
Nested IF - Incorrect Argument
Hoping someone may be able to spot my error. Attempting to return 1 of 5 statuses (Complete, Not Started, Late, Pending, or In Progress). I think the challenge is with the Pending status, where I am trying to flag a due date within 7 days of today. =IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(),…
-
Filtering and sorting at the same time
Hi community, When applying a filter I cannot filter the filter result. Any clue how to work this around ? Best,
-
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…