-
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.
-
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?