-
Form conversion
Does anyone know if I can convert the data collected via a form on a tracker sheet to a Project plan? Whilst I appreciate there may be few tasks/mile stones etc. am I able to automate this first initial step? Thanks & any help appreciated
-
Name Displayed in Workspace vs. My Smartsheet Contacts
Hello In my My Smartsheet contacts, I have everyone entered as their name and then their email address. But when I share a workspace for some of the folks (not all) it just shows their email address. So then when you assign them a task it just shows their email address but I want it to show their name. Do I have to delete…
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
Dashboard Chart Labels & Range
Hi I have a couple of questions: 1. How do you change the font on the labels (under series)? 2. How do I set a common range (e.g., 0-100%) vs the chart automatically setting it? Here is a sample graph:
-
VLOOKUP Formula for Dashboard Updates
Hi there, I have a dashboard widget and I'd like it to automatically update every time a row of data is added to the a SmartSheet (see attached screenshot). I'm trying to use a VLOOKUP formula on the top row to always pull the latest data, but it's not working. Any formula wizards out there that can help? Thanks! Susan
-
Formula for Text
Can I use a formula to capture text from the cells below it. For example, if I have "IT-1900" in row 2 and "IT-1901" in row 3, can my summary row show "IT-1900, IT-1901"?
-
conditional formatting using two date columns
Hi, I use several date columns to track my project, for example, a start date, a finish date and an actual finish date. I want to apply conditional formatting so that if actual finish date is not equal to finish date, meaning a task can be finished ahead of schedule or a delay, then highlight that row. I tried conditional…
-
COUNTIF, ISBLANK, and OR formula
For a particular project category, I'm attempting to count how many times the "Project Status" column is either a blank cell or not "green" (aka complete). These projects will be marked as "Active" on my stats sheet. Here's the formula that I have thus far and I'm receiving an Invalid Operation error: =COUNTIFS({CDVL…
-
Filter display
Hello, I need a little help to get the filter to work properly. In a report, I applied a filter to get a display based on people and later by date but the display does not give the right result. You can see with the screen shoot Thanks
-
Stop Auto Formatting
I have a sheet with manually entered rows that are formatted gray to signify a day and if it's AM or PM. Users can then start filling in items below that row. When they enter their data, the sheet is using the auto-format function and also formatting it gray which is causing confusion. How do I stop smartsheet from…
