-
Need a formula to add a today's date in a date column
Hello Everyone, I am looking for a formula that will add today's date if certain criteria has been met. If "Approved" or "Denied" has been entered into the Status column I would like today's date to automatically be entered in the date column. Thanks in advance. Stephanie
-
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.…
-
Outlook for Windows
I am trying to add the Outlook Add in. I just got Office 365 business. It installed outlook on my Windows 10 and brought over my old emails and email addresses. But I can't get it to integrate the Add In. It had me set up a .on.microsoft.com account, I have a feeling this is messing me up somewhere. Any thoughts? I am sure…
-
Store cell data on specific date
Hello, I'm needing some help in figuring out if it's possible for smartsheet to pull data to a cell on a specified date. For example I need to hire 5 people for a building opening on 12/1/2018, but they need to be hired 8 weeks prior. What I want to do is have one cell that takes the hired count cell and pull the info on…
-
Project Sheet dates
Is it possible to use Month 1, Month 2, Month 3, etc. instead of actual date names (Jan, Feb, Mar) in the heading?
-
Outlook Add In no longer working
Using Outlook to access an Office365 account, and I have long made extensive use of the Smartsheet Add-in. I've dealt with the browser login issue before, but today I got a new error that is very different. "ADD-IN ERROR" "A problem occurred while trying to reach this add-in" Anybody else getting this?
-
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
-
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?
-
Deadline column from Creating A Master Calendar video...
In https://learn.smartsheet.com/master-calendar, the presenter uses "Gantt Project With Hard Deadline" template to create projects, then in Report Builder uses the "Deadline" Column for filtering. However, when I use this same template, there is no "Deadline" column, nor is there a "Deadline" column available from the…