-
% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…
-
Copy rows to other sheet as values only?
What are some tips please to copy/move rows to other sheet as values only? Specifically, rows which contain column formulae. Is there a known workaround, or should I just use DataMesh? My main issue with this is that I can't copy columns containing column formulae. Thanks for your help, Matt
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?
-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Duplicating a Report Sheet in Smartsheet
Hello. I have a report, and I want to use the same settings / filters on the report page but for different projects, so I "saved as new" and renamed it at the top, BUT, how do I clear it out so there's no existing information entered that's on the original report? ( I hope that made sense ) - any help or suggestions are…
-
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Formula to insert date and/or time
Hi All, Whilst I use a 3rd party app for shortcuts when typing, its fully functional in Smartsheet. I am seeking the formula to insert the date in a text field while typing. Example in MS Excel the formula is &[Date] however this doesn't work in Smartsheet. I use Smartsheet via Microsoft Edge.