-
Auto Populate Dates
Hi All, I have a smartsheet and am unsure the work arounds with date formulas. I have two columns one referencing when a task should be completed and one with an actual delivery date of task. I am trying to enter in something to auto populate dates for these tasks based on the initial start off date. Can anyone help me…
-
Auto Downfill?
Is there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said formula? This can help users decrease their time entering formulas and allow ease of…
-
Using Sumif within the sum range
I'm trying to sumif my % complete (and eventually average that number) within a summary row in the same column above. I can do this for 1 row, but when I fill the formula down it creates a circular reference and blocks the row above as well. Is it possible to solve this without using a helper column? I've also tried using…
-
Formula
I'm looking for a formula that would let me update the status column when the %Complete has a value entered. It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in the status column. If the % Complete value is 100% then the status column would show "Complete"…
-
copy formulas from one sheet to another
I have created a block of formulas 4columns x 13rows that are each unique (with complex COUNTIFS formula) counting values etc. with different features. I would like to copy this formula block to another identical sheet. When I copy paste directly or ask it to copy the rows to the new sheet the formulas are erased and only…
-
How to Concatenate multiple cells into a single cell within a VLOOKUP formula?
I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet get entered into the cell on the 'staging' smartsheet. For instance, I'm looking for entries on the source smartsheet that…
-
Calculation from number in a checkbox column
I'm trying to create a column that would allow some groups to report progress as a percentage and some to simply check a box for 100%. I've written my formula, but as soon as I enter a number within the checkbox column I receive the #Invalid Operation error. Any help would be appreciated. =IF(Progress4 = "True", 1 *…
-
How to determine how close I am to linking limits
Hi all, Is there a reasonable way to know if I'm getting close to the cross sheet link limits? Thanks, Darrell
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
COUNTIF Formula Help
Hi I am trying to work out how to do a a COUNTIF formula but I can't get it to work. I have a sheet which contains some payment details and have created an exceptions report that shows invoices that have been submitted but not yet approved which works fine but we want a widget to show a figure of all the exceptions in this…