-
IF statements
So I have this formula for the 'Assigned to' column: =IF([Updated by]1 = "jillian@email.com", "alex@email.com", "mark@email.com") where if someone updates and saves a row, if the email of the person who updated matches the one in the IF, it will assign to the first employee, otherwise it's assigned to a different employee.…
-
Linking smartsheet cells to Google sheets
Can we link a particular set of cells or values from Smartsheet to a Google sheet? If yes, then how can we do it?
-
Mutiple If's in a statement
Hello, I am trying to created a multiple if Statement. If column1 contains "Milestone 1" show "30% invoiced If column1 contains "Milestone 2" show 80% invoiced If column1 contains "Milestone 2" show 100% invoiced Can someone please help me created this formula?
-
Account Locked Out
Hi, Can someone here please point me in the right direction: I have another Smartsheet account that is currently "locked due to an accounting issue" I have asked for support twice more that 8 hours ago and nobody gets back to me. How do I get support? TY
-
multi criteria for Conditional Formating
Hi, I have a SmartSheet to show the meeting schedule. It has several columns: strata manager, building code,.Supplies given to SM (date) ,Reminder to Accounting department" (this has the formula inside to show the date) I just want to highlight the column of strata manager as green as for the following condition: 1.…
-
Kanban (Subtasks)
I'm using Zapier to auto-create a task but I want the task to have subtasks as well and it seems like I can't do this through Zapier. Any idea on how I can set this up automatically, so that when a new task is created the same 8 subtasks is always added to any new task through Zapier?
-
Update Request for Specific User
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these change as a project moves along. I have several people outside my organization where update requests work perfect for them…
-
Moving attachments and comments to a new sheet
I have since decided to combine multiple sheets into one master sheet (I was beginning to duplicate data and tried to put a band-aid on it with cell linking). I did a Save As New..from the most complete sheet of all of them. The problem is, I have a bunch of attachments and comments on a few different sheets that I want to…
-
Import Google Forms?
Hello. New user so forgive my ignorance. I'm testing the potential transition of many of my current G Suite functions over to Smart Sheet. Currently, I use a Google form to input daily information which compiles to a Google Sheet. To save time, I would rather import that Google Form rather than creating a new one in…
-
TIP: Look out for incorrect years in your project plan.
If you find in a sheet that a task is not appearing with other tasks in the gantt chart or the gantt chart is defaulting to a date that is far away from the rest of the project then double check that the year of all tasks are set correctly. For example, ensure that the date 12/01/17 is in 2017 and not in 1917. You can…
