-
Automation to include Attachment (email notification), but there is no attachments?
I have set up to sent the notification once the task is assigned to a person. That notification should include the key information's columns and also attachments. It used to see the PDF icon in the email coming through but it is no longer there. Once you click the link to open the form, I can still access to it, but there…
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
Summary Formula
I'm trying to get a formula set up in the sheet summary to get rows added within the last 90 days, and then a vlookup to get a cell value. I've tried numerous formulas but they're all coming up with an error =IF(TODAY() - Created:Created <= 90, VLOOKUP("Reviewer", [Peer / Reviewer Rating]:Trust, 10, false),) any ideas…
-
define user
Hello, I have a specific cell. When a value is entered into this cell, the person who entered the value should fill out a form from another sheet. I've tried to implement this through a workflow, however, in my sheet are many editor columns as there are different roles in a row, so it's not possible to define who should…
-
Exporting a form
It would be great to be able to export a fillable form from the SmartSheet instead of having to use Document Builder.
-
Calculating 2 criteria from one column up to a specific date, also including a check box reference
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (working days will be 28 June). Also ensuring that a check box for if it's being reported is checked. I'm using a sheet…
-
Converting Multiple IF function instances to column formula
Hi, I am trying to set up time sheet for employees where formula in the column will calculate their income for hours worked. Employees are using form to enter their hours. I have set up their individual hourly rates in the summary sheet. "Amount Earned" Column contains formula. Formula is: =IF(Name1 = "Worker1",[Work…
-
Adding Image to Cell from gdrive URL automatically using Python & Smartsheet API
Hi All, I am currently trying to automatically adding image into a cell in smartsheet using Smartsheet API and Python. So, we have two column : Column A containing image URL Column B where we want to add the image from gdrive URL I have hundred rows, meaning we have hundreds cell on column B to add image from column A. I…
-
Document builder error, when use two different languages in a cell
Document builder gives an error when using two different languages in a cell. It's okay if you only write in Korean. It's okay if you only use English. If you mix the two in one cell, the value will not be entered properly. Please fix it.
-
Exporting group members
I'm wanting to do a review to make sure I have everyone placed in the right buckets. I can dump a user list but there's no group membership details included. I don't see any automated way of dumping group members to CSV for review. The best solution i found is stupid -- open each group and copy-paste the html into excel…