-
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…
-
Moving Cards In Kanban Is Not Updating Grid
Hi guys, I have just started working with the Agile template and I have noticed that if I move a card from say Backlog to Sprint 1 in Kanban view, it does not update the change in grid view. Is this normal behaviour?
