-
Data validation for multiselect dropdown lists?
I am embedding a Smartsheet form in an online training module, to collect and validate the answers in the absence of an LMS. For a single dropdown, I found it easy - I create a question column, in which I collect the answer, and an answer column, in which I validate the answer. To validate the answer I use a simple IF…
-
Remove "In Progress" from formula, but comes back unparseable
Good morning! I would like to change the behaviour of the below formula that defines rag status... =IF(Status@row = "Complete", "Gray", IF(AND(Status@row = "In Progress", [Due Date]@row > TODAY()), "Yellow", IF(Start@row > TODAY(7), "Green", IF([Due Date]@row < TODAY(), "Red", "Yellow")))) I would like to remove the…
-
International Holidays
In MS Project you're able to apply a calendar to a specific task. I understand you can't do this in SmartSheet but I'm wondering how people get around that? We have to consider China holidays and we typically just apply a non working calendar to that part of the timeline so that we understand the delay. Surely there are…
-
Lock Request Update Action
Is there a way to lock/stop being able to use the button sent in a Request Update Action in the workflow? For example this button gets sent via email and after a certain date if they click that "open update form" button, I want the button to not allow them to make updates. I tried deactivating the form, but it still…
-
Combined Calendar Report - Can I Automate Labels?
Hello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on my team can see a calendar of all their tasks for the week or month, with multiple…
-
Have lag be reduced when changing dates
Hello. Is it possible to have a change in dates affect lag: say I have a shipment coming in that I need for certain tasks. between this shipment coming and us needing to use it in the task several other tasks are being done. I therefor use a predecessors with lag to show/indicate which tasks are in need of this shipment.…
-
date Automation
I want to set up an workflow automation to look the last working day of a month. I use the sheet as an input sheet and to not want change the date of the trigger monthly. I do not see an option for last working day. Please advise
-
Project dashboard milestone report
Has anyone figured out how to surface a milestone report to a project dashboard and only have one date column; due date? Milestone are due on a certain date (start and end same date), they are not between two dates so all I want is the task name and due date and the gantt view. When I deleted all but these two columns…
-
You have exceeded the maximum number of emails that your account can send
Hello, I vae encounterd with tes message below. I wrote the help desk but I havent received any mesage so far ( 3 days passed). I checked everwhere but I cannot see what shoukld I do.. Can you help me? Thanks, Aaydin
-
Parent - children sum up formula.
Dear All, I need a formula by which I can automatically sum up all the values of the children row in the parent row. It would be great if the parent row gets the sum up all its children row, if there is 2 or 20 or more children rows inside the parent row, automatically. Thank you
