I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work.
Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in …
I am looking at ways I can automate export a smartsheet to excel at regular frequencies.
I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content.
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 Functions65KDub618
Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
API & Developers34Peter Kafui Doviavu
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 Posts79Michael.Baker
Hi SS Community!
Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me.
Currently, I have this:
=IF(AND([Start Date]@row < (TODAY() + 14)), NOT(…
Formulas and Functions62Kristina Howes
See sample below. How can I fix the formula, or what should the formula be?
Using Smartsheet48Johan Schwab
We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process.
Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
API & Developers102tcalvey
I would like to check cell [Actual Finish Date}4 for a date before executing =IF(ISBLANK([Planned Finish Date]4), 0, IF([Planned Finish Date]4 < TODAY(), 1, 0)) which sets a FLAG to true. If [Actual Finish Date}4 has a date then set FLA…
Formulas and Functions11mtaekla
I am wanting to have completed forms auto emailed to an email address that will be supplied in one of the fields on the form that is not the submitters email. Does anyone know if there is a way to do this?
I didn't know if this could be …
Hello everyone, I'm looking for a way to add projects (color project lines) in one sheet. In the solution center, there is a project category and in it there is a task list option for each project. In this option specifically, I wish…
(Total noob with SmartSheets)
I’m using Smartsheet URLs in an LMS training course at the end for feedback and suggestions. Currently we construct the link inside the course and it opens a web form when clicked with some of the fields pr…
I created a draft version of a workspace, now I need to transfer it to a licensed user and I get:
"You have exceeded the maximum number of emails that your account can send"
How can I get this fixed????
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
Using Smartsheet83[email protected]
I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all differen…
Formulas and Functions26dcabras
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to r…
Archived 2015 Posts75Jeremy Michels
I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder.
I understand that we could copy …
Formulas and Functions186stephanie.smith
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
I will try and explain this without messing up
* We are using smartsheet to track fabrication of product
* each row is an item we fabricate
* each item has a budgeted amount of time per task designated in a column
* they ar…
Formulas and Functions14BESP10
I was working on a way to track some task hours and minutes... came up with this:
One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
Formulas and Functions699Ezra
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 repo…
Formulas and Functions76ross74231
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…
t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible?
Formulas and Functions164Luis Cazares
I cannot find a pre existing template in smartsheet templates
Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre …
I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displ…
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works.
Formulas and Functions998Briana White
I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting dura…
Formulas and Functions144jochav5280
Has anyone had success packaging their python applications for smartsheet into executables with pyinstaller? I've tried adding hidden imports, updating spec file, and running a clean venv with python 3.4 yet I still get an error message th…
API & Developers66SamuelDrescher61351
Could the SmartSheet community get an update on the successor column from the products team? I believe this was first requested a few years ago in late 2015 and has been by others multiple times since then.