-
Can Smartsheet enter a date automatically based on a progress update
Is there a formula that would allow Smartsheet to automatically enter the current date in a separate column when a drop-down choice in another column is selected. For example, when the Progress column is updated (through the drop-down) to "Assigned", can a separate column called DateAssigned be auto-populated with the…
-
How do I create the formula I need? Dummy version
I used the formula =sum(qty1 * cost1) to get my total cost. I copied that formula down my total cost column and have a bunch of blank rows showing $0.00. How do I adjust my formula to leave empty rows blank?
-
Combining Multiple If(And( Statements
Hello, I'm trying to create a formula that will look at a language, the agency, and the status and fill in $ amount. I have written six different formulas that all work but when I try to combine them I get the error message, incorrect argument set. Here are the formulas: Sign Language - BY =IF(STATUS@row = "", "",…
-
How can I improve/automate my workflow?
I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account. I currently do this by generating a User List Report in the User Management section of the Admin…
-
Counting blank cells when the column is being used for roll up metrics in another sheet
Hi All, I'm working on creating dynamic metrics using a roll up metrics sheet. I'd like show the total number of tasks for each status and the total that has no status assigned. Easy, right? =COUNTIF({Column Name},"Status Type") or =COUNTIF({Column Name},"") the problem is the total number of tasks by status type exceeds…
-
Formula for parent row that calculates % of child rows, based upon date durations
Hi all I use a manual formula in my parent rows to calculate % Complete, because we chose to have the % Complete column update automatically based upon the Status column ("Complete" = 100%). The parent rows have the following formula: =IF(OR(Status@row = "Complete", Status@row = "Not Required"), 1, AVG(CHILDREN())) Which…
-
Increment Auto number column based on check box or other trigger
I'd like to set up a check box or some other trigger that tells the Auto number column to do its thing. This will NOT always (or usually) be a new row and it will be a row with Children (and it's a Child too). That's why I'm looking for a trigger to increment the auto number. Can this be done? Jeana
-
If/countif returns incorrect arguement
So I'm using the following formula and getting errors. =IF(COUNTIF([ID Dump]:[ID]), "CURRENT", "NEEDS") Basically, I'm trying to get a return of CURRENT if any of the values in the "ID DUMP" column are in the "ID" column, and then a NEEDS if the number in the "ID DUMP" is missing. I used the following formula in excel and…
-
I want a blank cell to return a symbol in another cell
This is a pretty basic question that I'm sure has been asked before, but I'm having trouble finding an answer. I'm using the below formula, but I need to add an additional rule so that if the Loaded cell is blank, it would return the "Hold" symbol. I've tried some variations of ISBLANK, but haven't gotten any to work yet.…
-
COUNTIF with AND or COUNTIFS --> Not sure how to make this work; neither formula I tried is working
=COUNTIF(AND({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"])) =COUNTIFS(({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))