-
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…
-
It's finally here! Card View in Reports!
Hi everyone, I hope you're well and safe! Woohoo! It's finally here! Card View in Reports! 🤩 Card view is now available in reports! Combine your project sheets into one report, then view in card view to quickly answer questions like: Which tasks are high priority? How many issues are in the Implementation stage? Which…
-
Viewing cards from multiple different projects, all on one board
We use a separate gantt timeline for every project. We also use a simple grid to capture to-do tasks not relating to any specific project. We want to be able to view all cards from all projects, on one kanban board, to get an overarching view of everything going on. Can someone please tell me a simple way to do this?…