-
Can I reorder card fields?
I love the new Card view, and am easily creating new fields and showing/hiding from view. But I can't see a way of reordering the fields on my card? I've tried reordering the columns in Grid view, but doesn't seem to reflect on the card. Am I missing something?
-
Use more row content as the default text of the subject field when sending a quick update.
We would have a huge increase in productivity if we could use more than just the primary column row content as the default text of the subject field when sending a quick update.
-
Uploading a photo for the community
This is a very silly question. However, I have tried to upload a my photo to my profile. But, nothing happens and no photo is displayed. I know it warns that it needs to be smaller than 1024x1024 pixels and I have made it smaller than that. What is the trick to this? I thought about sharing a formaula technigue that I…
-
#DIVIDE BY ZERO” error
I have a formula in Smartsheet that calculates Accuracy by using the following formula: Estimated amount-actual amount/actual amount. Until the “actual amount” is filled in (sometimes weeks or months later) the formula returns a “#DIVIDE BY ZERO” error. The error is fine as far as the calculations go on my pivot tables.…
-
Counting rows after filters applied
I'm hoping this is a simple question with a simple answer but when I apply my fiilters to a SS, I need to count up how many rows are left, after I've filtered out the data I don't want. The rows are no longer sequential and are numbered to include the hidden rows and counting the rows manually would be a long painful…
-
Help with Sites and Sheets
I'm struggling to create two things in my Smartsheet. I'd like to have a countdown in the completation date from "today" until our project's expected final day. And capturing the %done of the project in smartsheet, maybe I'm doing something wrong but the =AVG() is not working for me. I'd like the program health to indicate…
-
Auto-increment a new form entry if it matches an existing name
My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing). I'd like to find a way to automate one of the questions in the form - how many times we've interacted with…
-
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every…
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
-
Ordering Search Results
Is there a way to order search results from the Current Sheet by their line number within the sheet?
