-
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…
-
SUMIF Formula Help
Hi I am trying to work out how to do a a SUMIF formula but I can't get it to work. I have a number of columns, one is a fee column (formatted as a Text/Number) and the other is a payment received column (formatted as a date). I have parent/child rows and want to perform this function on a parent row so it sums the…
-
Link a summary sheet to multiple workplans
I'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate project plan as they are shared with different stakeholders. Each project plan has an overall RYGB status, based on the 'worst'…
-
Trouble with nesting formula, could use some advice
Hello, I am attempting to use nested formula's to create a status update. I started with, =IF(NO(ISBLANK([Date Submitted to Engineering]),"Sent to Engineering")) and it worked fine. The problem is I need to add multiple status options, with automation like this. So I added the second status and it will not work. Here is…
-
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this
-
If/And statements
Hi All, So, I am trying to set a trigger flag to be checked when a request is within a certain amount of days and not approved or denied. I would like the flag to trigger a reminder email to the approver indicating the request is imminent and they have yet to approve/deny it. I can't seem to get the IF/And function to work…