I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
Formulas and Functions10Sonny Mendoza
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows:
We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions42Melissa P-B
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …
Using Smartsheet9Jonathan Forrester
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns.
I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…
I have 2 sheets:
1) working sheet where all tickets are logged + their status is maintained
2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working…
Formulas and Functions18Stefan Milic
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in …
I'm working with two Smartsheets.
(1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions31Amy Arnold
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocuse…
Using Smartsheet44Rob Ford
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on.
All I want to is to create a line-type chart for my d…
Using Smartsheet13Laura Corredor
I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times…
Using Smartsheet17Rachel Peabody
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format…
Hi SmartSheet community!
This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…
Using Smartsheet25Zoe Charalambous
I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app.
When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and sh…
Using Smartsheet51Connor Hartford
when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User En…
Using Smartsheet17Steve Bertram
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions274UnaB
I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form.
I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
Formulas and Functions14Amy Arnold
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is,…
Formulas and Functions35Drew Frazelle
I want some of my users to be able to submit data using forms. But in order to be able to fill out a form, the users must have shared access to the sheet that contains the input form in question.
With sheet sharing enabled, the users …
Using Smartsheet15[email protected]
I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet.
The only approach I can think of is…
Formulas and Functions20xav
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I …
Using Smartsheet20Nicole Campbell
I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
Using Smartsheet189Tal Segal
I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION.
Here's my Master Smartsheet.
This is the formula I started using based on responses in the c…
Formulas and Functions25Amy Arnold
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project.
Most of the reports and dashboards I've tried to crea…
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions16Mike Wilday
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers153katherinehall
I put together a workflow that sends an email for approval, however whenever the project is approved it email blasts the contact who made the request (sends out like 7 emails/notifications) that all say the same thing. Is there a way to o…
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet83Michael Lockwood
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…