- Update Forms: Can they be created without the automated email link generation?
I have an intake sheet with multiple projects and instead of sending a project manager an automated email with a link to an update form to change any information regarding a project, is there a way to have a form be a standalone link in the intake sheet that when clicked opens up a form in a new tab. From there, the user…
- COUNTIFS based on Children criteria of certain row
Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of the project being completed. Goal: Count the number of active projects per month based on % complete being greater…
- 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
他llo! 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…
- 验证公式
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
