-
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over?
=LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…
Formulas and Functions4
Iris Fuentes
-
Hi All,
I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula:
=COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
Formulas and Functions244
RySols
-
Hi All,
I have Word documents I am attaching to a smartsheet, that I would like a team member in the field who uses an Ipad, to be able to edit easily and save back to Smartsheet. Without too many steps involved.
PDF is also an option.
…
Using Smartsheet35
michon71241
-
Hello,
We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs.
The dashboards are updated automatically with every changes in the master project and pro…
Using Smartsheet37
Cyril_H
-
Hey
Please see attachment.
I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank.
I basically want to count the amount of RFIs with…
Formulas and Functions46
[email protected]
-
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1.
I've tried a couple of times and non of my rows are copied.
To test it, I added to the same automatio…
Formulas and Functions48
Stelina Todorova
-
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.
It has many application & the proof of concept exists and we use it.
We use it for an approval process (for in…
API & Developers587
JeremiahHorstick
-
Hello,
I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month,…
Formulas and Functions28
Deena Duran
-
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 …
Using Smartsheet51
karen.michel99046
-
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row.
For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours…
Formulas and Functions44
dplunkett79331
-
Hi,
I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out?
=COUNTIF(CHILDREN(), 1) + ""
returns the count of checked boxes.
=(COUNT(CHILDREN(), 0) + ""
returns the count of total rows, c…
Formulas and Functions71
craigwaco
-
Many of our team members have iPhones and the new photo format apple is pushing is .HEIC.
When we upload their photos to the attachment line they are not able to be clicked on and viewed the way a JPEG is. Seeing that this a new direction …
Using Smartsheet25
@iamhunterabrams
-
hey everyone,
i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person.
…
Using Smartsheet13
Aditya Muhammad
-
In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this …
Premium Apps and Integrations64
M. David
-
Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …
Formulas and Functions44
M. David
-
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…
Using Smartsheet29
Tucker Webb
-
Hey
Is it possible to have the the drop-down list of a column changed based on the value of another column?
Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…
Formulas and Functions977
[email protected]
-
How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is…
Using Smartsheet85
alycia104251
-
Hi,
I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet.
Right now they are using a sh…
Using Smartsheet50
Ian B
-
Hi,
I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet.
Right now they are using a sh…
Using Smartsheet50
Ian B
-
Thought I would start my own thread regarding this since it seems very quiet around this change.
Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?
I am using Windows 10, Chrome webbrowser and swedish keyb…
Using Smartsheet50
Mattias
-
Has anyone received this error message before? What are the options for large data?
(Image)
Using Smartsheet200
David Skinner
-
Hi everyone!
New to Smartsheet and trying to figure out the automation aspect - which is what really sold us on the software. So, I have a question - is it possible to send out notifications/alerts based on specific changes within a row…
Using Smartsheet29
dawn73751
-
Hello all,
I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additiona…
Formulas and Functions81
Nick Monroe
-
The dashboards that I've created for out Project Management teams contain a report that lists all their active projects with a hyperlink to a project schedule (A different Smartsheet Grid).
I've been asked if it is possible for them to o…
Using Smartsheet251
RMRGSA
-
Hi,
I need help to solve this puzzle. I'm using this sumif formula
=SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value})
to sum up the total value of invoices against a particular o…
Formulas and Functions33
kane.godfrey
-
Hi All,
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 Functions50
KDub618
-
Hello,
I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desi…
Using Smartsheet87
SupplyChain
-
Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO. Have tried many combos an…
Formulas and Functions51
dskpetersen
-
Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In …
Formulas and Functions54
M. David
