-
SumIf across SmartSheets
Is there a way to create a sumif formula that references cells on a different sheet. If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values match worksheet2 comlumn5 values. Example: =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2) I can't figure out,…
-
Feature Request: Mimic specific sheet(s) in Report
This can be done manually, but is time consuming: I would like a Report that mimics a specific sheet*. That is, the Report would display all columns in the same order as displayed in the sheet. Currently, this is a manual process which is OK for a sheet with a dozen (or even two) columns, but I'm working with sheets that…
-
Change in "Assigned To" column removed it from Card View
I have created an Assigned To column as a Drop Down list, but I really wanted to use the Contact List function to be able to have the links to email. I created a new Column, renamed the first Assigned 2 and made the new column a Contact List. Now only the "Assigned 2" column appears in the Card View "View By:" dropdown. I…
-
Web form confirmation emails with multiple fonts
Has anyone experienced web form confirmation emails displaying multiple fonts? I have a client who set up a web form and is having this issue. Some information is in Arial, some is in Times Roman. I've tried to replicate things on my end, but my confirmation emails are all Arial. I'm wondering if it has to do with the…
-
Automating Balls
I have a formula that works for some of the functionality. I am having an issue getting the gray ball to work using this formula. =IF(AND(TODAY() - [End Date]4 > 0, [% Complete]4 < 1), "Red", IF([End Date]4 - TODAY() < 4, IF([% Complete]4 >= 0.9, "Green", IF([% Complete]4 > 0.5, "Yellow", "Red", IF(AND([End Date]4 <=…
-
Seperate worksheets for 1 project all linked together
Hi, I have a master plan in excel and then i have seperate worksheet for Risk Log, Decision Log, Issues Log - can i have multiple sheets for just 1 project in Smartsheet? Thanks :-)
-
Migrating a smartsheet from one account to another
Hi everyone My client is so smitten with Smartsheet that they are joining the Smartsheet community with their own account. How do I go about migrating the worksheets I've set up for them on my account to theirs? Thanks for your answers. Isabelle
-
Conditional Date Calculation
hi, I have months columns Aug-2016. .Sep-2016 etc., (just the names of the Column are months, but the Column property is Text/Number) and each month has a number value. I'd like to be able sum those numbers based on a condition - The current month's number + 4 more months from the current month should be summed. Eg: When…
-
Feature Request: Search Both Sheet Name & Content Simultaneously
I'd love to be able to put both sheet name and content string into the search box and it find what I'm looking for. For instance... We have a sheet named "UIN" that has our store names and unique store numbers. I'd love to be able to search UIN Woodway and it find the cell that I'm looking for. Right now, I have to search…
-
Date option in column properties
It would be useful to be able to scroll through years as well as months for delivery dates more than months ahead
