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 an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
Using Smartsheet14Alejandra Orihuela
I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent.
Is there a way I can sort my c…
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Curre…
Premium Apps and Integrations97tcanelli41471
In the available columns to display in a report, there is no option to show the row number of the record from the source sheet. Is there any alternative way to accomplish this? If not, can Smartsheet team please add this to the feature enh…
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advance
Formulas and Functions306odedL
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions207EmilyH
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLAN…
Formulas and Functions21Shirley Vue
I was wondering if this is possible yet, or if there have been any updates?
Importing from Smartsheet into Outlook is nice, but I would love to have…
Using Smartsheet197Paul Newcome
So--I have basic formula knowledge but feels like I'm outside my wheelhouse.
All I want to do is return a specific start date based on a couple criteria:
Week (1-7, beginning 2/20/20)
Start time (morning, midday, night) Note: all m…
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
Formulas and Functions15Quran Fulton
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.
Excuse me, my english isn't very well. I need your help.
When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to …
Using Smartsheet34Lisa Savard
I am wanting to create an approval workflow that requires different levels of approval. The number of levels depends on where the request is coming from. As an example request comes in that requires Director, VP, and CEO approval to procee…
Hoping I can get some assistance from the Gurus around here.
Currently, we have an =IF formula that looks at the Due Date of a project and:
* if the project is today, it returns THIS WEEK
* if the project was last week,…
Formulas and Functions45DiAlmeida
Hi, is there a way to automatically merge rows to a google document when a new row is added?
Example: We track phone monitoring in a sheet and want them to auto-merge into the Google Doc or PDF instead of someone having to do manually.
I'm working to have a request sheet move rows to a active list sheet. I'm getting the following error and having trouble finding information on what column name actions I need to look to correct.
Any help pointing me where I can find col…
Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact w…
We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-…
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions50KDub618
I am at a loss at how to even start this design.
I have approximately 15 tasks that occur every month on the same BUSINESS day
I have another 5 tasks that occur on the same business day every quarter.
I would like to…
Have a super basic question I just can't seem to find a quick answer for.
Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell wit…
Archived 2017 Posts2479Dereck H
Can anyone recommend a purpose-built portable device for scanning barcodes that could be used with the SmartSheet (i.e. not a smartphone or tablet)? We're looking for something we can use in a laboratory environment, so it should be fairly…
Using Smartsheet40Chuck Mihaliak
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts55Michael.Baker
Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.
I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out.
Formulas and Functions53tmccray
Is this possible, only seem to be able to add one at a time, is there a way to add multiple?
I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements.
In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…
Archived 2015 Posts324Loann McGee
I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this;
IF([Contract Type]=NDA, John Doe)
So if Contract Type equals NDA, then put John Doe in the Assigned To field…
Formulas and Functions36Shawn Borror