-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…
-
How to set a formula for 3 different values to prevent any duplication
Hello Everyone, I hope all are doing well. I'm facing an issue to find the suitable formula to my case taking into consideration i'm a newbie here in smartsheet and would appreciate your kind support. The formula i'm looking for is targeting 3 main columns : Start Date, End Date & Facilitator. To assure that if a…
-
Two Form Solution - Multiple Lines in a Smartsheet & Special Conditioning
I was grateful to receive an email from Andree in relation to a two form solution for submitting one form with multiple lines of data; however, I have two additional questions. In Andree's file there is a toggle on the main form to generate the results from the two forms. How do I create this toggle? Additionally, the data…
-
I would like to compare week number with column name
I have a column for each work week of the year (1 to 53). I would like to append the value of HC Plan on its respective column, based on Start Week and End Week. For example, if a project starts on week 1 and end on week 2, I need to append a Head Count of 5 to the columns of Work Week 1 and 2, to keep track of HC needed…
-
Check box formula help!
I am wanting to set up a formula and/or conditional formatting so that when you check one box, it automatically un-checks another. example: two columns side by side. one titled "job started" the other titled "job done." I want it so as soon as you check the box for job done, it removes the check from job started. This…
-
Actual date against Original Date Conditional Formatting
Q: What is conditional formatting to have Actual: WB Completed date match up against Workbook completed date? Then shade it red if late, no font change if before or on that date See picture for visuals and thank you in advance for your time.
-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
Sheet to Sheet with Parent Rows
I have created a sheet that when a check box is marked it moves the entire row to another sheet. I was wondering if there is a way that when the row moves to another sheet if I can have it populate the information under a parent row? Example my Scheduling sheet moves the row to my Machine sheet. My scheduling sheet I make…
-
clone conditionnal formatting
Hi, when I clone conditionnal formatting because I want to apply it to multiple columns, it erases the criteria that I wanted to keep, how is that cloning it? example: column1 goes red when "in the next" "50"days clone it, change to column 2 and insterad of staying "is in the next" "50" it changes to "contains"
-
Salesforce Connector and Sync Status Function
The sync status for Salesforce Connector automatically pulls rows that are filtered out and puts them under the "Filtered out by Connector" Section. Is it possible to adjust what Smartsheet's does if a row is not syncing? I would like the row to stay where it is and instead do a conditional formatting type option where it…
