-
Smartsheet Automation to push data to Google Sheets
I want to create an Automation that when a cell is changed in Smartsheets a corresponding google sheets gets updated. The upper management uses google sheets, so when we update our Smartsheets we want the google Dashboards get updated real time. Any advice of directions that can help.
-
Attempting COUNTIF(AND
Hello! I am trying to create a formula to count inspections created by a specific driver each month. I keep getting "Incorrect Argument". Do I need to separate the columns differently? =COUNTIF(AND({Vehicle Inspection Checklist Management Sh Range 3}, IFERROR(MONTH(@cell), 0) = 1, {Vehicle Inspection Checklist Management…
-
Using Symbols to represent a numerical value like percentage
I am trying to create some visual queues on my smartsheet. I have a % Complete column that essentially shows how far along we are between the start and due date. I'd like to represent these percentages with symbols to provide visual queues about our progress. In this case, I am trying to use the little smiley/frowny face…
-
Couple of Time Formula Questions
Background. I have 4 columns: Status, Status Date, IRB Submission Date, and IRB Elapsed Time. We want whenever the Status changes (In Preparation, Submitted, Approved, Complete, Cancelled) to record the date. I thought this formula would work: =IF(Status@row = "Approved", TODAY(), IF(Status@row = "Complete", TODAY(),…
-
Sheet Summary
Is it possible to remove an entire sheet summary from the Sheet? We have changed a lot of our reporting needs and I want to start fresh - is there an easy way of deleting the entire contents in that summary area without having to manually go on each field and delete? Also, if I have one sheet summary set up is it possible…
-
% Complete Formula
I know I'm totally wrong, cause it's not working :) If I want to say take start date and find the difference from today's date and then divide by duration and place in % Complete column - how do I formulate that in smartsheet ? Thanks in advance!
-
Why doesn't my dynamic cell reference display in the alert email?
I have an alert set up to trigger when a date is entered in a column on the row. Also on the row is a date that is calculated. I included the name of the calculated date field in {{ }} inside the message body to dispaly the contents of that row's column in the alert. However, the data is not displaying in the email. It…
-
Return Multiple Rows Using VLOOKUP and COLLECT
Good morning, I am working on a formula which will return multiple rows of data from a different sheet based on criteria. For context, I am looking to view all the cells from sheet A (defined in a range) where there is a value like "BA Edit" in sheet B. I have tried doing this several ways, with no success.…
-
Getting a number from another sheet
Hi I am trying to have a totals sheet. So I need to get the totals from other sheets and add them to the main sheet. I am confused by the formulas they are asking me to use. I need the total enrolled students from Honeybee (4 on bottom) to the top screenshot. Please help!
-
Mismatch between custom duration formula and project settings duration column
Why do I often get a 1 in a custom duration calculation of same-day work vs. project settings calculation, which shows 0? During some import troubleshooting, I created a "baseline duration" and "revised duration" column to compare my own formula for calculating duration to the durations provided by project settings. My…
