-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,…
-
upgrade from individual to... individual
Hi! I have an individual plan. When I try to create a report I get a popup window asking me to upgrade to an individual plan, which I think does not make sense. Any ideas on how to sort it out?
-
IF statement help to determine active sprint
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is between [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave it…
-
Update Request that uses cell color
Good Morning, I am using Smartsheet to track students that are Below Grade Level, On Grade Level and Above Grade Level. The cell color for Below Grade Level is red, On grade level is light green and Above Grade level is dark green. When sending an update request for certain rows to one of my teachers, the colors in the…
-
COUNTIF Does not equal
Hello! I'd like to set up a formula to COUNTIF(Children)<>"app/registration complete" so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up). Can't seem to get it to work. Is "does not equal" possible for COUNTIF in Smartsheet? Thanks in advance!
-
New JIRA tickets don't appear in linked Smartsheet file?
I'm using the JIRA+Smartsheet connector app. I created two sample JIRA tickets and was able to get these tickets to appear in a Smartsheet file. I then created 600 new JIRA tickets and these aren't syncing to the same Smartsheet file even though the same filtering criteria should be met. Can someone help me to troubleshoot?
-
customizing the email address for a request for approval
Has anyone played with the Request for Approval option? I'd like to be able to send this request to a client to approval work in progress. However, the email the client receives comes from "automation@smartsheet.com." I'd like to customize this so that it comes from me (like notifications do) so the client will recognize…
-
Simplifying my formula
I would like to simplify a formula (if possible). Several items in the formula below have the same value (e.g. 25 or 10). =IF([Activity_1]1 = “JTA”, “25”, IF([Activity_1]1 = “IDW”, “25”, IF([Activity_1]1 = “Lab Builds”, “25”, IF([Activity_1]1 = “TR”, “20”, IF([Activity_1]1 = “VCDX Def”, “15”, IF([Activity_1]1 = “VCDX…
-
Count down in days formula
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
