-
Attachments
Is there a way to deny being able to check a box complete until an attachment is added. Thanks in advance
-
Alternative to VLOOKUP in SmartSheet?
Is there a 'bolt-on' in Smartsheet that does the same thing as VLOOKUP?
-
Vlookup or Index with Match?
Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the formula for this? this would be an import from salesforce that I would have to do manually weekly, so I could rename the imported file and use same column names each time.…
-
Identifying a ticked checkbox in an =IF formula
Hi there, I'd like to use an =IF formula to identify those cells where the checkbox is ticked - does anyone know what syntax should be used to identify a ticked checkbox, i.e. =IF(cell = ????,1,0) (where ???? = ticked checkbox)? Thanks, Paul
-
Auto fill due date based on my auto filled start date
I have my start date auto filled when I enter information into a new row. I now want my due date to auto fill to 7 work days after the start date. How do I do this? Right now I have this for row 5 =WORKDAY([Start Date]5 + 7) Any help would be great!
-
IF todays date is between start date and end date then check this box
I need to run an active projects report that collects data on in progress projects. I need to put the formula into the checklist column so that it checks it if todays date is between the start and end date.
-
Hyperlink function
Hello all, Is there a way to do the following: =if value in Column A, return hyperlink to Column B This is not a website hyperlink, this is a hyperlink to a smartsheet item. I have tried pulling hyperlinks through VLOOKUPs, nested if statements in the same sheet, etc. Manually clicking through and adding hyperlinks 1 by 1…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Help with IF formula using Today formula and unparseable error
I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal")) I want the sheet to check if a task is not yet marked complete (<100 %) AND the current…
-
Formula calculating monthly totals
I am trying to write a formula that will calculate receipt totals by month (starting this month) Here is the formula i am using, but it is returning an invalid data type =SUMIFS({Joseph Nelums- CRS Expense Reporting Receipt Total}, {Joseph Nelums- CRS Expense Reporting Date}, YEAR(@cell) = YEAR(TODAY()), {Joseph Nelums-…