-
SUMIF(OR(???
I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half…
-
Citrix's Sharefile and Smartsheets
Can I attach a file from Citrix's Sharefile to my Smartsheets projects/forms/etc?
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Docusign *Help Needed*
Does anyone have a docusign/smartsheet "how to" instructions? I have tinkered around a bit but am having a hard time recreating a workflow in smartsheet labs. I think the issue is setting up my docusign template. Thanks in advance! Sarah
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Circular Reference / In Excel it works / SOLVED
This has been solved now :) Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. Saves some 30+people now a lot of work. Hi there, we are stuck transforming some sheets…
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
Formula for a future meeting date (after today)
Good morning - I have a series of columns with scheduled "future" meeting dates. I want to populate one column with the date of the next scheduled meeting. Have tried importing the formula which works in Excel over, but Smartsheet keeps on saying "INVALIDOPERATION. Help please !
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
