-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
Countif Query
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the…
-
Latest Discussion comment viewed in a cell
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what the latest comment is without switching views.
-
Global Updates and using VLookup formula in it.
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not successful in accomplishing that. Please some suggestions.
-
Is it possible to hyperlink text in a form.
This would allow the user to access additional information when completing the form. I have placed a link to some information in another sheet but the link is long. I know there are applications that shorten urls but I would prefer to hyperlink the text.
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…