-
Indenting on smartsheet causing calculation error- help?
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
Can I set calendar view to open to today's date?
Hello, Last week we noticed that our calendar view was opening to a date several years in the past (Aug 2015) rather than opening to today's date (which it had been doing successfully all of 2021). This sheet was completed in 2021 so there are no dates entered that are prior to the creation date. I have changed the…
-
Docusign Integration - Attach final Envelope as separate docs?
We are using a Template Docusign Envelope (with multiple documents in the envelope) and sending that via Smartsheet Generate Docs Docusign Integration. When the doc envelope is complete, the document attaches as one combined PDF in Smartsheet. Anyone know if there is a way to have these attach in Smartsheet as separate…
-
Copy Problem Excel To Smartsheet
Hi there ; i can not copy any cell excel to smartsheet , is there anybody has the same problem today too ? or ho can i solve ?
-
Large criterion name
Hello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation. The working formula is as follows,…
-
Nested If SmartSheet Formula For Symbols (R, G, Y)
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
-
Maximum Downloads
Has anyone ever encountered this issue? We sent out a single line from SmartSheet that held four attachments to approximately 180 individuals to download. For most it worked wonderfully. Now, we're getting this message: "Unable to download file. The download URL has exceeded the maximum number of uses." Of course, I now…
-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
