-
Need help with Form capabilities!
I am trying to create a temporary process for employees to submit time and expenses. There is a Entry Type Field that specifies which fields are displayed based on if it's a time or expense. For Time - I have logic set up that based on the date a new field will appear labeled as which day of the week corresponds to the…
-
I want to populate a Quote with information from a price list sheet
Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU / Stock code into the quote and have the…
-
How do I change a row color based on another rows date?
Hi guys, I am looking to change the text color in the row labeled "Projected Start Date" to red if the date in the row "Actual Start Date" is beyond that projected start date. I assume this is something that conditional formatting can help with, but I can't seem to figure it out. Can anyone help with this? Thanks!
-
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…
