-
Alert emails
Hi everyone! I am looking for a way (if possible) to remove the row data from the email alerts. I can create a custom message to relay only the information I want, but it adds all the row data at the end of the email. Is there a way for the alert email to ONLY send the custom message I create? I have already tried this in…
-
Tranfer of Ownership Issue
We are having trouble transferring ownership. I had a user transfer her ownership to me but it still shows her as being the owner on my end. When she goes to the smartsheet it shows me as the owner. Any suggestions would be helpful!
-
Pinning the menu Bar
Does anyone know whether there is an option to pin the menu bar, When you work in multiple sheets it is handy to have the menu pinned when required? Have looked and look and not sure if this is a function yet. Thank in advance for your help.
-
Use Smartsheet for an easy way to start spreadsheets rather than Excel?
I am a sub-novice when it comes to spreadsheets, so this will seem like an extremely dumb question. I don't have to use or create spreadsheets too often in my work, but when I do, its usually for some information I need to get to administration yesterday. The spreadsheets I create are fairly simple. I would like to use…
-
Find and Change Resources in Alerts
We have a staff person (A) that retired and is being replaced by another staff person (B). I ran a report to tell me where she (A) was allocated as a resource in the various sheets, and was easily able to change those tasks to the new resource (B). However, I know that the retired person (A) also received alerts based on…
-
Is there a column or range limit to Vlookups?
Is there a column or range limit for Vlookups? My Weeknumber I'm referencing is in column 1 and the number I need is in column 33. The error its giving me is #Invalid operation. It seems that I can handle 31 columns but anything after that, it gives that message.
-
Hierarchy in Smartsheet and Jira Connector not working
I don't seem to be able to get any hierarchy to work using the Jira connector. Smartsheet Hierarchy When I first sync'd my smartsheet with Jira all the rows were rearranged and the entire hierarchy in smartsheet was lost. So I figured out I need to use Group by in the Jira connector to respect the Smartsheet hierarchy.…
-
COLLECT and ISBLANK
Hello community, I have a sheet called Boundary. ColumnA is called "Distance" and has integers . ColumnB is called "distance_to_increment" and has either an integer or a blank field. From another sheet called Summry, I would like to sum, all distances which have a blank field for column B. I struggle with the formula, for…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Dynamic View - Delete a View and Change Source
How do I delete a Dynamic View that is no longer required Please? How can I change the source Sheet or Report used to create a Dynamic View, please? Thanks, Si
