-
LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees: (35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee % I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on…
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
Alpha order or Sheet Order Column List
When working with columns, such as creating a report or Dynamic View, it would be beneficial to have a choice when designing to either add all columns in alpha order or add all columns in the order they appear in the source sheet. Currently, you have to add them one by one and scroll through the alpha list to put them in…
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
Time tracking in RM
A teammember is unable to track time to one specific project. They can track time to every other project and the settings are the same as everyone else's. Any ideas?
-
Rolling and Automated Inventory
Hello Smartsheet Community! I've been attempting to set up a rolling and automated inventory and have ran into a mind splitting concern. I've been able to set up a Master Inventory, Incoming/Outgoing sheet, and a Rolling Data sheet to speak to one another with notifications to notify when a currently stocked item needs to…
-
Automation and Forms
If i have a Microsoft template that i have to collect information and fill out. If i created a form to collect the information that's needed for the Microsoft Template, Is there a way to utilize the information from the sheet to automatically fill out that template and email it out to respondents on the list?
-
Is it possible to do?
I have to ask as I am hitting a wall here. I want to create a resource/solution where people can claim things : The work flow consists of Two parts. Section A and Section B. Section A (completed already) Section A is form where User A fills up to show/post what's available to claim from recently added items which I will…
-
How do I unhide workspace menu?
Hello, when I collapse the workspace menu, there is no button I can see to click to unhide workspace menu. I've googled the issue and there seems to be no way to get it back without refreshing several times and trial and error. The below screenshot is how to hide the menu… How do I unhide workspace menu?