-
Grouping dates in reports not working as expected
We have started using the grouping function within several reports and grouping on a date field but we are coming across tasks with the same dates not appearing within the same grouping? We are not grouping by any other column and the formatting of all dates across all sheets is the same? Has anyone else discovered this?…
-
Create a dynamic link to "drill down" to a source sheet from a report
I know there has to be a simple way to do this but I'm not finding it and I getting into crunch time on this project so, HELP! :) I have a sheet that has a bunch of projects on it. I am pulling a report to a tracking sheet that folks will use as a starting off point to look at project progress. Whenever I add a new project…
-
Requesting help with ""Length of Stay" formula as per Excel
I am receiving the #UNPARSEABLE message for the following formula to reflect length of stay between two entered dates using =IFDATED([MOVE-IN DATE]1,[ASSESSMENT DATE]1,"Y") & " Yrs, " & DATEDIF([MOVE-IN DATE]1,[ASSESSMENT DATE]1,"YM") & " Mnths, " & DATEDIF([MOVE-IN DATE]1,[ASSESSMENT DATE]1,"MD") & " Days" Please assist.
-
Fiscal Year Calculation
Hello, I am trying to have a column that calculates a fiscal year automatically based on whether the parent Completed Date falls before or after July 1. Something that follows this logic: If the parent "Completed Date" month is less than 7 (July) display "FY 'Parent Year'", otherwise display "FY 'Parent Year + 1'", if…
-
Trouble with Project Management & Smartsheet Restrictions
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome these issues without having to turn off all dependencies. Without dependencies the product doesn't offer much for project…
-
Reports Not Updating Live
I'm trying to shift our company towards using reports more, instead of multiple people interacting with sheets directly (and thus making version control difficult when minor items are changed, particularly on Control Center provisions) -- To this end, I've been given feedback about reports that indicate that they do not…
-
Why can't my clients view a Report?
We publish a pricelist to our retail customers, as a report but we are receiving complaints because they can't view. They do not have Smartsheet accounts and nor do they want one just for our price lists. We need to keep them updated automatically with any price changes. I have attached a copy of what the latest customer…
-
Census Information for a company
Is there a way to add and delete employee info with an automation and formula. I need to get accurate count of how many people are in the company and what tier they fall into. I would like to have an up-to-date sheet. Updated Census Sheet
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…