-
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
-
Forms
OUr forms are randomly requesting participants to complete a CAPTCHA request, however, we have not added this to our account and if it is going to show we want it to happen with every form submitted and not just random few. How do we correct this?
-
Send Update - To update only selected cell?
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
