-
Feature Request: Attachments viewed from workspace level
I still miss being able to view attachments at the sheet or row level from the workspace level. I don't miss it often, but usually when I do I've just lost 30 minutes looking for the attachment I know was on one of the many sheets in the workspace (and it was). Work-around is to request a backup and check there. I…
-
Lookup if date is between 2 dates, then return an associated value (same sheet)
Hello:) Is there a way to lookup a date, determine if it falls between 2 dates (fiscal year quarters), and then return the corresponding value? ie: Date: 1/29/2016 Fiscal Year Q1: 1/1/2016 ~ 3/31/2016 Fiscal Year Q2: 4/1~June 31/2016 etc So, the formula would check to see if {date} (1/29) is between 1/1 and 3/31, or…
-
Automated update request.
Is it possible to send automated update request on a specified date (column date)? I'm missing the function where, an automated update request is send on the date of a deadline.
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
-
Smartsheet for business
I used smartsheet earlier this year and liked it for several things, like excel on steroids. But then as my business grew I needed more systems to manage sales, customers, inventory, etc. etc. I found myself signing up for more and more software solutions. The year end is a good time to review everything so I'm looking at…
-
Can I use LOOKUP function on mutliple sheet
Hi Team, Can I refer the range (table) of different smart sheet to look for a value of another smartsheet where the LOOKUP is used ?
-
Printing CardView
How come you can't print a Card View or share a sheet in Card View?
-
#INVALID DATA TYPE formula Return
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
-
S-curves
Hi everyone, Someone knows if it's possible to make S-curves with Smartsheet to track project progress? If it's not, have you found any convenient way to make S-curves out of your Smartsheet data? I mean without copying manually the data to an excel or MS Project file. Best, Jason
-
Best way to calculate stats on a sheet tracking form submissions
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…