-
isFormula function.
I would like a way to determine if a cell contains a literal value or a formula calculated value. For example: On a project sheet we have multiple date fields for different actions to complete on the same item. By default we use formulas to generate estimates for all the date columns. Some users may enter an actual date to…
-
Is there a list of hex code / color codes?
Is there a list already generated for the 40 colors available for selection? ie #FFF200 = Yellow Craig
-
My Cell is Red for NO Reason!
The title says it all. I have a cell, inside a column (obviously lol), and its red. I have no idea whatsoever why it is red. Is it mad at me? (lol okay, no more jokes I promise) I do have lots of conditional formatting in my sheet, and in this column too, but the other cells are behaving as expected. I tried satisfying the…
-
Drop Down List
Does any one know how to add a date and comments in the same field. For example - "08/15/2018 Left Message". I want the date of the activity to be documented in 1 field.
-
Match Two Entries from Two Separate Form Sheets, Assign Status
I have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated number from the "Assignment" form to reflect the production done for that assignment. I'd like have a RYG ball on the…
-
Summing of colored "conditional" cells
Hello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition not met cells? There are 25 cells that have conditions in them.
-
How to create an auto incrementing number based upon checkbox
Hi everyone, I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Installs this year". In this column, I want to create a formula that checks the "Gone Live" field, and if the checkbox is…
-
Linking action items to project tasks
Hello everybody, first time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smartsheet, so would appreciate help in getting a solution for my workflow I have a project sheet, with task names, start & finish dates, predecessors (dependencies enabled),…
-
Detecting Cell Changes, Modifying other cells on update.
Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…
