-
Sharing Templates
I use templates as my archive system. I want to share my template sheets with my supervisor, but I don't see a way to share templates. Can I? If not, it looks like I can move the sheets to a workspace to share. Should I build my archive in Workspaces instead of under templates?
-
Settings for Checkbox Column
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
-
Accessing a web form on Android app
Is there a way to access a web form on the android app? I can access the form on the desktop version and through the email link but I don't know if it's accessible on the app. Does any one know?
-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
-
Card view - spanning lanes
Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit
-
Simple email capability?
is there any way to load an email address into a smartsheet cell and then send an email to that address simply by clicking on it?
-
Conditional Formatting on Parent Line
I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
-
Managing Resources by duration and not % allocation
Is there a way to manage resources by time rather than having to use % allocation please? Any way aound this? Its actually not that easy to manage using a %. Sad that smartsheet didn't think it would be an important feature. I'm no software expert, but seems like not too difficult a fix if they already implemented it for…
