-
Same subtasks for all projects..
Hi all, I'm new here, so sorry if the question's been asked before and I couldn't find the answer, but: I work on multiple projects at once, and they typically have the same group of tasks for each (I work in communications, and for every event (/project) I draft the same suite of products, and they get approved in the…
-
I would like to combine 2 columns together when we send an email from a row
I was wondering if there is a way to combine 2 columns together when you send an actual email from a row to have everything on one line rather than 2?
-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
-
Help with Totaling Against Options in Multi Select Drop Down in a Report?
Hello! Here is my scenario - I have a set up like this in my sheet (this is of course dummy data just to give a visual of the sheet structure) - I am trying to create a report grouped by the "Assigned To" so that I can summarize the # Hours each person is assigned, and then have a chart widget from that on a dashboard. I…
-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…
-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Possible to create a URL/Hyperlink for new item (Automatically)?
We would like to create a URL/Hyperlink for new item automatically...in the attached example I had to 1) Manually go to row, 2) Select Properties, 3) Copy the Row Link, 4) Paste the Row Link in the field. We would like this to happen automatically, so far everything I have read says it is not possible. Someone have a…
-
Merged: Form to Modify Existing Row
This discussion has been merged.
-
Schedule Health Balls Change Based on End Date and Status
I'm looking to have the schedule health balls change color based on the "Status" and "End Date" columns. Green = "Complete" OR "In Progress" with more than 2 days to "End Date" Yellow = "In Progress" with 0-2 days to "End Date" OR "On Hold" Red = Not "Complete" after the "End Date" Thank you!
