-
Column Limits vs Data on a Single Row
TLDNR (short version) GOAL – everything in reports / sheets to be on one row per project PROBLEM – I run out of columns and reports won’t merge data from multiple sheets to one row. (long version) Typical spreadsheets can present as one project row and all it’s details in columns to the right (scrolling is left to right)…
-
Old Notifications
There is an old Notification going out to my Team, I created this a while ago and want to edit it but I can't find it in my Manage Alerts ^ Actions menu. I made note of the Notification ID that is being sent out. Is there any way to search for this Notification by ID? Or how else can I find this notification so I can edit…
-
Link to most recent output of a form
I'm new to Smartsheets and trying to use a form to collect data on one sheet and then link the most recent output of that form to another, master sheet. However, I can only seem to link a specific cell to a specific cell and the form populates a new row each time someone submits a new response. What is the recommended way…
-
If Blank, leave blank otherwise Networkdays fomula
Is there a way to create a formula that only runs if there is a date in a specific coloumn? We are trying to see turnaround times but do not want to see #invalid if the document has not been exected yet.
-
IF formula on Dashboard
I would like to show on dashboard most important numbers including the latest License Expiration Date. I already created "help column" in the same smartsheet as data, where I use formula: =IF([Expire data license]@row = MIN(COLLECT([Expire data license]:[Expire data license]; [Expire data license]:[Expire data license];…
-
How do I address a "pending" update request?
Hi I'm new to Smartsheet and can't seem to find how an answer to this. I've just located an Update request that has a pending status (found in smartsheet, not an email). How do I actually action the request and change the status from pending to complete? thanks
-
Smartsheet for Insurance Solutions
Good Afternoon, I wanted to check to see if there are any users in the Property & Casualty Insurance Industry and if so, could you share what you are using it for? I am a new user and still learning all its capabilities. I see that there is a large Healthcare following but not sure about the P&C world.
-
Deciding what rows go on my calendar view
I have done this before but can't get it to work this time. In fact, in my current sheet. However, I can't remember how! I have a checkbox column called SHOW IN CALENDAR. I want the check box to determine what shows in the calendar view. Did I create a separate filter with this before? I just want what I want to show in…
-
Time of day
As an event planner I need to assign start and end times i.e. 9:00 a.m. - 3:00 p.m. to meetings and tasks that need to be completed. I can obviously type in the times, but they do not sort correctly as anything starting with a "1" regardless of AM or PM will shoot to the top. I can put a "0" in front of any AM times, such…
-
Report Sorting Assigned To Column
Hi, I had posted another discussion about an issue, but I think I have another issue that might fix my previous issue if I can resolve this current issue. I was having trouble with manipulating tasks and having a view of all resources to be able to manipulate tasks. Here is that post:…
