-
Referring to Adjacent Row
I am using the following formula in Color column to shade every other row in a sheet: ROW 1: No formula ROW 2 = IF(Color1 = 0, 1, 0) ROW 3 = IF(Color2 = 0, 1, 0) I have over 1,000 rows. This works fine. However, if I insert a new row, I have to drag the formula from the row above all the way down to the last row the fix…
-
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
-
Row Color For Easier Visuals
Good afternoon, Is there a setting that we can set up so that every other row is a different so that it is easier to follow data across all columns when looking at the sheet? Would like every other row to be gray to tell difference from the white rows. Thank you
-
Viewer Send Email and Add as a Comment
Is there a way that someone who only has Viewer access can send an e-mail to Smartsheet which adds the content of the e-mail as a Comment? As far as I understand, they do not have the ability to add Comments directly, since they only have Viewer access.
-
SignNow integration
Anyone successfully integrate SignNow with Smartsheet? What can be integrated? Can forms be autogenerated from data in Smartsheet, and form creating/emailing (using email, named, etc. in Smartsheet) and signing via SignNow be recorded in Smartsheet automatically (e.g., activate merge in smartsheet via a trigger, which then…
-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Multiple Selections from a Drop Down
Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple…
-
Adding Outlook calendar entries into a Smartsheet
Is it possible when creating a calendar entry within Outlook, to have that entry automatically populate a new row in a Smartsheet sheet?
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
