-
Percentage of Child Rows with Check Mark
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, check or unchecked. So I divided the two, but I get #INVALID OPERATION error. Any thoughts?
-
Proofing Review Request
Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not who would use proofing. I want to make sure anyone can send out a review request, but wasn't…
-
Need a way to identify if a row has been approved/rejected via proofing
Hi, I am using the new feature "Proofing" for my upcoming project and I was wondering is there any way to identify if a document on a row is approved/rejected, then use it in the custom formula to change the status of the row? For example if a document is rejected then I would like to change the status of the row to…
-
About the approval request for spesific people
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. so, i create the approval request by the trigger with Division 01, and Division 02. But the…
-
Use Modified Date to show when the last time a sheet was edited.
I would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By columns on my sheet. Somebody started helping me with this, but kinda trailed off. I understand…
-
Log of user access to sheets
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 will show information on 20-25 projects, so automating the solution as much as…
-
Multiplying cells from different sheets
Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the corresponding cell from Sheet 1 and then be able to copy/paste the formula so that it…
-
How to bid Materials - Construction question needing solution:
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 solution to take a materials count for my given tasks and then fill in the info I'll…
-
SUMIFS formula question
I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way to do so even when the columns are NOT next to the other? Here are snapshots: The…
-
Smartsheet and Trello - Custom Fields import to Smartsheet
Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/articles/504553-import-files-to-create-new-sheets, which is working correctly, however,…