-
Keep Workspace/Folder Structure when Bulk Transferring Sheet Owner
How can I get sheets to remain in the workspace/folder when bulk transferring a user's sheets to someone else?
-
Changing colors and company logo
Hello everybody, I'm a licensed user and want to change the color of the sheets and the company logo. When I click in the account the "Personal colors and logo.."button and pop up window opens and want to upgrade me. As I don't need this, I close the window and I am back to the original screen. Can anybody help? Thanks,…
-
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…
