-
Count days between start and end date
I want to show count of days between start date and end date
-
Checkboxes
Is it possible to remove a checkbox out of a single cell even when you require them in the rest of the column?
-
Referencing a Contact with VLOOKUP
I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list. I have another sheet, a time sheet, which needs to reference that supervisor column with vlookup so that approvals can be sent to that person for hours logged. It…
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
RGB Balls IF Function on 4 Colours Rules
Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula. Grey = IF Stock Column is “ “ (empty) Red = IF Stock Column is “0” Yellow = IF Stock Column <= Critico Column Green = IF Stock > Critico Column Could you give me a…
-
Report that looks at more two or more criteria but the criteria do not all have start dates
Hi. I'm trying to build a report that will tell me when we are close to sending bills for a district to the print shop. The criteria is looking at two rows with different names in the Primary Column; i.e. Request Information and Original Proof Signoff but I need different criteria for each when it comes to dates. For…
-
RGB Balls Format
rgb balls format I have not been able to set the "status" column to show the RGB balls after programming an IF formula as I show it in the attached images. As you can see the column is edited as Status RGB but the result is delivered in text and not in color balls. I appreciate your prompt help
-
Sumifs with 2 conditions in same column
I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition: =SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Team}, "Computing", {Team…
-
Auto-Number on Certain Rows
Forgive my naivety as I'm still green at formatting. I'm trying to use the Auto-Number function in a column. I don't want all cells in the column to populate - only if column c isn't blank. I can't seem to get this to work where the auto-number will popular a cell if column c contains anything?
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen