-
Can you create an order form in Smartsheet
I am wanting to create some order form for my company, but i cant seem to be able to create a section where they are able to put in more than one product at a time. What colunm type would i use?
-
HELP
Excuse me, my english isn't very well. I need your help. When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to me (cut, copy etc). My mouse works very well except for that
-
Checkmark Parent if any Children Due Date is in the next 7 Days
Hello! Stuck testing out formulas to add a Column [Children Due Soon] that checkmarks if a parent row [Task Name] has any children task is due [Due] in the next 7 days. I've been trying to edit the famous RGB formula for this, but still not very familiar with formulas. Thanks!
-
Using IF, AND, OR
Looking for formula advice/help! I would like to write a formula that will: Mark Past Due if Complete By is greater than today + task is not complete If no Complete By date exists, than Past Due flag remains unchecked So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a…
-
Count "text" if the status is "Doing"
I'd like a way to count Theme column (Text Column) if "IVR" appears, AND if the Status Column (Dropdown column) is either "Backlog" or "To Do" or "Doing" I can get a simple countif formula to work, but can't figure out how to add a second criteria based on status i tried ones along the lines of =COUNTIF(AND(Theme:Theme,…
-
Reminders email notifications
Good morning all, I have a question regarding email notifications sent when a reminder is set in a row. Is there a way to set the reminders emails to be delivered at a specific time on the due date specified? Every time we set reminders, we are getting the notifications between 2 and 4 am. This is a bit impractical as…
-
Validation Formula
Going crazy. My current formula =IF(AND([Time Missed / Used (In Hours)]1 < 19.99),CONTAINS("Not", [Excused/Not Excused]1:[Excused/Not Excused]1, ".25", "1"))) = #UNPARSEABLE The goal here is to return .25 or 1 into a cell "Totals" if cell "Time Missed / Used (In Hours)]" is less than 19.99 and cell "[Excused/Not Excused]".…
-
Reminder visibility
When adding a reminder to a row in Smartsheet, is it possible to have the reminder visible only to the person creating/entering the reminder? I'm thinking this is not possible in Smartsheet now - if it is possible, please advise! Does anyone know if there is a plan to have this available in future? Thanks, Olli
-
Is it possible to add a delay to a task if it doesn't have any predecessors ?
I have few tasks in my sheet, which are not independant of other tasks. The dependencies have been swtiches on in the gantt view. Is it possible to add a delay to these tasks without manually changing the dates ?
-
How can I format a sheet or report to create a customer facing inspection signoff
Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sheet showing all measures that were inspected where they write down the quantity of…
