-
Wrong date format on hyperlinks
Hello all, I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displayed in US date format. Is this a glitch or are we doing something wrong? Tom
-
Formula for changing drop-down selection in one column when a date is entered in another column
I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Another automate RYG balls for parent based on child
Hi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF(Status@row = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row >= TODAY(+3), [Due Date]@row < TODAY(+7)), "Yellow", IF([Due Date]@row < TODAY(+3), "Red")))) What I want to do is create a…
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
RAG status formula using TODAY and end date
Hey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TODAY or in the future should be green any task up to 3 working days in the past should…
-
Email as form field and for copy of responses
My organization has just started using Smartsheet and I created my first form. I have a required "Email" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I announced the form and asked for feedback. Immediate and understandable feedback was, "Why do I…
-
Stacked Bar Chart with Percentages
Hi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the individual country-level progress. When I try to stack the bar chart of % complete,…
-
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…
